Power BI: Get the Last/Latest Value of a Category/Group
Problem Statement:
In the given data filter and show only the most recent row based on date/version etc.
Data: I have taken data where we have ID and date along with status. And we would like to show the latest status.
Solution:
We will use a DAX measure for that.
I have loaded the data to the power bi file and created the following DAX measure
Last Status = var _max = maxx(filter(ALLSELECTED(Data), Data[ID] = Max(Data[ID])), Data[Date])
return
CALCULATE(max(Data[Status]), filter((Data) , Data[Date] =_max))
Refer to the attached file.
