Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
Hello All ,
I have two table A and B and I need to create DAX for below SQL query on it -
select * from
select a.user,a.city from A1 a
left outer join B1 b on a.user = b.user and a.city= b.city
where isnull(b.user,'') = ''
where a.user not in (select user from B1)
order by a.city
Thank you for the reply
Go to Solution.
About how to convert sql to dax, I would suggest you to refer to the tutorial below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Can you provide a data sample?Many Thanks
Thanks for the reply. I have tried it but some of the KEywords are not working on Power Bi editor.
Please remove the key word "EVALUATE".
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.