07-09-2022 22:00 PM
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.
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.