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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, v-xulin-mstf ,

Thank you a lot for your interest. I am very grateful for all advice and help.
Screenshot with sample raw data below.

 

 

Kind Regards,

Alina

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, v-xulin-mstf !

    Thank you for your help! It'll help me in me next tasks!

     

    Kind Regards,

    Alina