Forum Discussion

shuhn1229's avatar
shuhn1229
Resolver I
3 years ago
Solved

Matrix Visual with Changing Names

Hi all,   I've been trying to think through a solution to this all afternoon and am drawing blanks. I have a table like the below:   Name Date ID Book1 1/1/2023 1 Book1 2/1/2023 1 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

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's avatar
shuhn1229
Resolver I
3 years ago

you are brilliant. thank you.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago
    You are welcome. Thank you for the kind words.