Forum Discussion
How to aggregate Data on Order+Article Level to Order Level?
Hi Power BI community,
I was trying to aggregate Data on Order+Article level to Order level on Power BI Desktop but it keeps crashing.
Basically I have a massive database (24 million records) in Order+Article level with metrics like Net Sales and Discounts and want to aggregate it in Order level (8 million distinct orders) and have the metrics in that level. An Order has multiple Articles.
Do you know any way of being able to achieve this? Thank you so much
A quick example
As-is (24 million records)
| Order ID | Article ID | Net Sales | Discounts |
| 1 | A | 5 | -3 |
| 1 | B | 3 | -1 |
| 1 | C | 7 | -2 |
| 2 | A | 4 | -2 |
| 2 | C | 6 | -3 |
To-be (8 million records)
Order ID | Net Sales | Discounts |
| 1 | 15 | -6 |
| 2 | 10 | -5 |
Power BI does that automatically for you. All you need to do is not include the [Article ID] column in the visual.
1 Reply
Power BI does that automatically for you. All you need to do is not include the [Article ID] column in the visual.