Forum Discussion
Anonymous
3 years agoNot applicable
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]
1 Reply
- amitchandakSuper User
Anonymous , refer
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8