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
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()
  )