Forum Discussion

gancw1's avatar
gancw1
Icon for Resolver II rankResolver II
3 years ago
Solved

Display most recent record or highest value for each category

I have a table of student marks with the date the tests are taken. Student Date Marks A 10/9/2022 50 A 11/9/2022 90 A 15/9/2022 80 B 11/9/2022 90 B 12/9/2022 70 C 1...
Need Help
gancw1's avatar
gancw1
Icon for Resolver II rankResolver II
3 years ago

amitchandak 

 

In your code

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))

 

What does this expression do ?

Data[ID] = Max(Data[ID])