Forum Discussion
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 date) for Measure 1, Baseline
I have tried
Test =
CALCULATE (
SUM ( 'DIM - Targets'[Volume] ),
'DIM - Targets'[Measure] = "Measure1",
'DIM - Targets'[Type] = "Baseline",
LASTDATE ( 'DIM - Targets'[Date] )
)
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
1 Reply
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