Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

LOOKUPVALUE WITH SWITCH CONDITION

Hi,
Does anyone have DAX code for this or how should I execute this in power BI,

LOOKUPVALUE(table[course code],
SWITCH(
Condition 1: table[item code] = table1[item code],
Condition 2: table[course title] = table1[course title]