Forum Discussion
Helper INeed Help with grouping and summing
Hi, oluong
Based on your description, I'd like to suggest you use 'unpivot' and 'group by' feature in 'Query Editor'. I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may make all column selected, click 'Transform' ribbon=>'Unpivot columns'.
Then you need to click 'Group by' in 'Transform' ribbon and set as below. Finally you can rename the columns to get the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Useroluong , Not very to me transpose or unpivot should help
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
oluongHi amitchandak , I'm so new to this..I forgot to mention I created the column here using:
In the links you gave me, it assume that the columns were to be created in the "Transform Data" using the editor, so I could not use the pivot and unpivot article. If I have to put these columns Cat I...Cat II using th query editor, I didn't recognize the dax codes, what would your further expertise recommend?