Forum Discussion
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 ...
Soooo, what is the logic to get from Table1 and Table2 to Table3??
Logic : always "a" = "I" and "d" = "m" and "e" = a measure (n+o)
Thank you
Kind regards,
Mvumelwano
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() )