SQL to DAX Conversion

[Anonymous]

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 

[Mariusz]

HI @Anonymous 

Can you provide a data sample?

Many Thanks

Mariusz

[v-yuta-msft · Accepted solution]

@Anonymous ,

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.

[Anonymous]

Thanks for the reply. I have tried it but some of the KEywords are not working on Power Bi editor.

[v-yuta-msft]

@Anonymous ,

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.