Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

SQL to DAX Conversion

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 

Need Help
Show and Tell
Tips and Tricks

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        7 years ago

        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.

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    HI Anonymous 


    Can you provide a data sample?

    Many Thanks

    Mariusz