How to get the most current status change

DAX DAX Calculations
1

I want to get the most current status for each name based on the name and date column. How to do this in DAX?

sample data table:

image
image511×757 11.2 KB

Thanks
Jojo

2

Hi @jojo,

Give this a go

Most recent status = 
VAR _lastDate = MAX( INPUT[Date] )
RETURN

CALCULATE( MAX( INPUT[Status] ),
    INPUT[Date] = _lastDate
)

.Change INPUT[Status] into INPUT[Date] inside MAX within CALCULATE for the Date.

image

Note that this can easily be done on PQ as well. See example in attached file.
Most current status.pbix (21.3 KB)

I hope this is helpful

1 Like
3

Both work fine as expected. Thank you!