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...
Need Help
Show and Tell
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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.

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

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