Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SQL to DAX convertion

Hi, everybody! Need help from experienced DAX users in converting SQL to DAX.  SQL query provided below. I'm just starting learning DAX, so far this looks incredibly confusing to me(   WITH CTE_...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous

     

    Here is the output:

     

    The pbix file is attached, please try it.

     

    Best Regards,

    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
5 years ago

What I prefer to use is the expression SELECTCOLUMNS.

SELECT
A.Field1
A.Field2
FROM
Table A
WHERE
A.Field1 = 'A'

Becomes 

SELECTCOLUMNS
   filter ( 'table'
      'table'[Field1] = "A"
      )
   , "Field1" , [Field1]
   , "Field2" , [Field2]
   )

 You can use a combination of Union, Generate and Naturalinnerjoin to create a different context.