I need help with a DAX calculation. I have a table AppStages which lists the different AppID’s, Stage Name and the Completion Date. The users want to have a filter on the Completion Date such that only the latest Stage of an AppID is shown on the visual.
Example: Consider I have AppID = 1, with Stage 1 completed on 1/1/2019, Stage 2 completed on 2/1/2019 and Stage 3 completed on 3/1/2019.
So when the user selects date range of 1/1/2019 - 31/1/2019 , only the latest Stage 3 should be considered. Right now it shows me all 3 which is not what I want.
I am attaching the pbix file I am working to demonstrate exactly what I am trying to achieve.