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 on a selection of dates in the slicer. In this article and video, I’ll explain how the pattern works with details of DAX measures.
Download the Power BI file with all the codes from my blog article here:
[ Ссылка ]

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

RADACAD courses: [ Ссылка ]
Our upcoming courses: [ Ссылка ]
Free books and tools for Power BI: [ Ссылка ]
Power BI Helper: [ Ссылка ]
Become an academy member: [ Ссылка ]

*******************

********
CONNECT with US!
********

-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]

********

#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

свернуть