Forum Discussion
Measure with Lookupvalue?
akov,
You may take a look at the following post.
https://community.powerbi.com/t5/Desktop/Find-last-value-based-on-date/m-p/293150#M129228
akov,
You may take a look at the following post.
https://community.powerbi.com/t5/Desktop/Find-last-value-based-on-date/m-p/293150#M129228
Sam,
Thank you for the response, that post solved my problem!
I created a measure using the following:
Mature Date Prior to May 1 2018 = MAXX(TOPN(1, FILTER('SUV Project_Critical_Milestone_Progression', 'SUV Project_Critical_Milestone_Progression'[Project_Milestone_Name] ="Project Mature" && 'SUV Project_Critical_Milestone_Progression'[Valid_From_Dttm] < DATE(2018,05,10)), 'SUV Project_Critical_Milestone_Progression'[Valid_From_Dttm],DESC), 'SUV Project_Critical_Milestone_Progression'[Report Date])