Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I would like to join 2 tables based on certain conditions.
Ex. is below - I would like to jojn the first to second table based on:
Col1/Col4 ONLY if Col5 is empty
Col1 and Col2/Col4 and Col5 if Col6 is empty
all Col1, 2 and 3 /Col 4,5 and 6 if the latter are populated.
How would you do it? I have not found a good way to do such a "conditional" join....
Thanks!
Kind regards
Valeria
Col1 | Col2 | Col3 | Col4 | Col5 | Col6 | Result | ||
A | F | G | A | result1 | ||||
B | T | Y | B | result2 | ||||
C | G | D | C | G | D | result3 | ||
D | H | D | H | result4 | ||||
Final Table | ||||||||
Col1 | Col2 | Col3 | Result | |||||
A | F | G | result1 | |||||
B | T | Y | result2 | |||||
C | G | D | result3 | |||||
D | H | result4 | ||||||
Solved! Go to Solution.
thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |