Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]
@ronaldg , 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
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |