Forum Discussion

BenazirMohammad

Helper I

6 years ago

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....

v-lili6-msft
6 years ago
hi BenazirMohammad

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

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-sql-server-data-in-power-bi-desktop-part-5/

Regards,

Lin

Community Champion

6 years ago

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Related content