Forum Discussion

Mvumelwano's avatar
Mvumelwano
Icon for Helper I rankHelper I
6 years ago

lookup without common column

HI Team, Please assist with DAX, I have 2 tables (Table 1 and Table 2) and i need table 3 (see below example). always "a" = "I" and "d" = "m" and "e" = a measure (n+o) Table1 codes no a 1 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
Soooo, what is the logic to get from Table1 and Table2 to Table3??
Mvumelwano's avatar
Mvumelwano
Icon for Helper I rankHelper I
6 years ago

Greg_Deckler 

 

Logic : always "a" = "I" and "d" = "m" and "e" = a measure (n+o)

 

Thank you

Kind regards,

Mvumelwano

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Perhaps create a measure like:

     

     

    New Measure = 
  SWITCH(MAX('Table1'[codes]),
    "a",LOOKUPVALUE('Table2'[score],'Table2'[code],"l"),
    "d",LOOKUPVALUE('Table2'[score],'Table2'[code],"m"),
    "e",[measure],
    BLANK()
  )