Forum Discussion

MarcinSV's avatar
MarcinSV
Helper I
7 years ago
Solved

How to change this SQL into DAX

Hello, Can I ask you for help with changing this SQL (working OK) into DAX? SELECT TIME_STAMP_DATE , DMS_DATABASE_ID , DATABASE_NAME , BLOCKED_CLIENTAPP , BLOCKING_CLIENTAPP ,SUM(I) FROM ...
  • PattemManohar's avatar
    7 years ago

    MarcinSV You can either achieve in Power Query Editor using "Group By" option or In DAX try using SUMMARIZE / SUMMARIZECOLUMNS / GROUPBY functions. If you are looking for exact solution, then please try to post the sample test data and expected output which will be helpful.