Forum Discussion
Solved
CONDITIONAL JOIN
Hi, I am fairly new to this and was wondering if anyone can help with this. I am not sure how to do a conditional JOIN in DAX or power query. Here is my SQL statement. Select t1.* ,t2.col4 ,t3....
If so, you may try to use sql custom query to import the data in power bi, here is blog for you refer to:
https://community.powerbi.com/t5/Desktop/Writing-own-sql-queries/td-p/465429
Regards,
Lin
You may use merge and append in power query to gey it. please refer to this blog:
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
If you still have the problem, please share some sample pbix file and your expected output.
Regards,
Lin