Forum Discussion
OSS
Helper III
Helper IIIAppended queries optimization
Dear all I have 12 sales tables. (Sales by monthes) Columns are: customer id, product id and amount. I append all 12 tables (queries) and get final result with more than 5 million rows. Could y...
tex628
Community Champion
Community ChampionIf you append with the names being the same this should be the result:
From here you can easily show total amount per customer or product.
OSSHelper III
Helper IIIYour are right tex628.
This is exactly what I have now. But I want to see 31+10+19=60 for 202 Customer.
If product id and customer id are the same I would like to sum the amount.
- tex628
If you create a matrix and then use your columns like this:
Aren't you getting 60 for customer 202?- OSS
In matrix view everything is ok. But, after appending I have 5 million rows. I want to merge these rows, sum amounts and get less row amount. Is it possible to group, or pivot, or merge my data on data level, not report level?
- tex628
Try this:
Left click on a column in power query and choose group by.
Use these settings: