Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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!