Forum Discussion

davidoz's avatar
davidoz
Frequent Visitor
4 years ago
Solved

Lookup another column in the same table

I am building a dashboard which shows the schedule of some equipment   The raw data comes in this format:   As part of the dashboard, I created this matrix below which shows the type of uni...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi davidoz 

    please try

    =
VAR NextDate = [Next Date]
RETURN
    MAXX ( FILTER ( TableName, TableName[Date] = NextDate ), TableName[Base] )
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi davidoz 

please try

=
VAR NextDate = [Next Date]
RETURN
    MAXX ( FILTER ( TableName, TableName[Date] = NextDate ), TableName[Base] )
davidoz's avatar
davidoz
Frequent Visitor
4 years ago

thank you! this worked great!