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,'') = ''
) a
where a.user not in (select user from B1)
order by a.city
Thank you for the reply
Solved! Go to Solution.
@Sara15 ,
About how to convert sql to dax, I would suggest you to refer to the tutorial below:
https://www.sqlbi.com/articles/from-sql-to-dax-projection/
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.
@Sara15 ,
About how to convert sql to dax, I would suggest you to refer to the tutorial below:
https://www.sqlbi.com/articles/from-sql-to-dax-projection/
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.
Thanks for the reply. I have tried it but some of the KEywords are not working on Power Bi editor.
@Sara15 ,
Please remove the key word "EVALUATE".
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.
Check out the November 2023 Power BI update to learn about new features.