Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
2 years ago
Solved

Return Value based on max date

Hello, i am trying to return the volume (marked in yellow) 0.906. it does not seem to be working, I think its something to do with the max date criteria.   i would like to return the latest (max da...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

NewbieJono , try measure like

 

Last Status = var _max = maxx(filter(ALLSELECTED('DIM - Targets'), 'DIM - Targets'[Measure] = "Measure1" && 'DIM - Targets'[Type] = "Baseline"), 'DIM - Targets'[Date] )
return
CALCULATE(sum( 'DIM - Targets'[Volume] ), filter(('DIM - Targets') , 'DIM - Targets'[Date] =_max))

 

 

Latest Date Date | Latest Data
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e