Forum Discussion
MarcinSV
7 years agoHelper I
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 ...
- 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.
PattemManohar
7 years agoCommunity Champion
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.
- MarcinSV7 years agoHelper I
Thank you for good direction, I'm working on it :)