Forum Discussion
Solved
Add aggregated rows in Query Editor?
Hello community, is it possible to add aggregated rows for all existing columns in a table within the query editor? In below image I want to aggregate based on YearMonth and Company so that a new "...
So, you could create a second query, reference your first query. Filter to just A and B. Create a column = "A+B". Now do a Group By to group by Date and your new column, appropriate aggregations. Now add an Append step and Append your original query.
DAX would be similar using SUMMARIZE/GROUPBY and UNION.
So, you could create a second query, reference your first query. Filter to just A and B. Create a column = "A+B". Now do a Group By to group by Date and your new column, appropriate aggregations. Now add an Append step and Append your original query.
DAX would be similar using SUMMARIZE/GROUPBY and UNION.