topic Group By For Two Columns in Dax in DAX Commands and Tips

Group By For Two Columns in Dax

Anonymous — Sun, 19 Jul 2020 11:00:28 GMT

Hi,

I want to write group by function in Dax. SQL is this ;

SELECT
A,B,SUM(C)
FROM Table
GROUP BY A,B

How to write group by for 2 columns in Dax or SSas ?

az38 — Sun, 19 Jul 2020 12:24:48 GMT

Anonymous

try SUMMARIZE() function

New Table = SUMMARIZE(Table, Table[A], Table[B], "SumC", SUM(Table[C]) )

amitchandak — Mon, 20 Jul 2020 02:42:30 GMT

Anonymous , If you have these columns ina table, you can simply put those to a visual , with A and B as not summarized and sum(Table[C])

That will work. If you want to create a new table then use summarize

summarize(Table, Table[A], Table[B], "_C", sum(Table[C])