Forum Discussion

MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
4 years ago
Solved

LOOKUPVALUE 3 tables

Hello, TableMain has ArrvialTime columns to lookup from 2 different tables. Table1 key is Group and Table2 key is Category Curretly I created columns : Table 1 ArrivalTime and Table 2 Arrival...
lookup
  • amitchandak's avatar
    amitchandak
    4 years ago

    MasterSonic , Create a new column

     

    coalesce(maxx(filter(Table1, Table1[Category] = tablemain[Category]) , Table1[ArrivalTime]) ,  maxx(filter(Table2, Table2[Category] = tablemain[Category]) , Table2[ArrivalTime]) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

MasterSonic , Create a new column

 

coalesce(maxx(filter(Table1, Table1[Category] = tablemain[Category]) , Table1[ArrivalTime]) ,  maxx(filter(Table2, Table2[Category] = tablemain[Category]) , Table2[ArrivalTime]) )

  • MasterSonic's avatar
    MasterSonic
    Icon for Helper IV rankHelper IV
    4 years ago

    you are star