Forum Discussion
Conditional Join in Power BI DAX
Hi,
I just wanted to know if a join (Merge Queries option) like demonstrated below is possible in Power BI.
case when dealer = null then table1.saleskey= table2.saleskey case when dealer is not null then table1.dealersaleskey = table2.dealersaleskey
Any workaround or suggestion would be helpful.
Thanks
Create a "Conditional Column" in the powerquery editor which has exactly your if conditions and then merge the query with your calcualted column.
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef
1 Reply
Create a "Conditional Column" in the powerquery editor which has exactly your if conditions and then merge the query with your calcualted column.
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef