Forum Discussion
Matrix Visual with Changing Names
Hi,
This calculated column formula works
Column = LOOKUPVALUE(Data[Name],Data[Date],CALCULATE(MAX(Data[Date]),FILTER(Data,Data[ID]=EARLIER(Data[ID]))),Data[ID],Data[ID])Hope this helps.
shuhn1229 , Try Measure like
Last ID = Var _max = maxx(filter( ALLSELECTED(Data1), Data1[Name] = max(Data1[Name]) ),Data1[Date])
return
CALCULATE(Max(Data1[ID]), filter( (Data1), Data1[Name] = max(Data1[Name]) && Data1[Date] =_max))
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
Hi,
thank you so very much for your help. I was thinking this through further and think it might be easier in this case if I could create a calculated column that would 1) filter by ID 2) filter by latest possible date 3) return the Name column. Could you walk me through how to set this up? This way I'd be able to use the Name column for each row in the matrix.
Hi,
This calculated column formula works
Column = LOOKUPVALUE(Data[Name],Data[Date],CALCULATE(MAX(Data[Date]),FILTER(Data,Data[ID]=EARLIER(Data[ID]))),Data[ID],Data[ID])Hope this helps.
you are brilliant. thank you.
- You are welcome. Thank you for the kind words.