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....
Go to Solution.
Refer to this article Merging with date range using Power Query - Exceed
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.