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.
Hi tonyclifton
Sure if you want to use your approach, please provide a sample table that can be copied.
You can always look at the DAX solution for Budget patterns below
https://www.daxpatterns.com/budget-patterns/
But I imagine that you would need an extra column that creates a hierarchy, like
| column | extra column |
| A | AB |
| B | AB |
| C | C |
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.