One of the common patterns in Power BI is to have a table with different statuses throughout time and then wanting to get the latest status up to a selected date. A simple example of that is to have a table with position(role) changes of employees and then wanting to see their latest position based … Continue reading Power BI HR Pattern: DAX Measures for the Last Position to Date: Last Status to Date