Forum Discussion
Appended 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...
If 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.
Your 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.
If you create a matrix and then use your columns like this:
Aren't you getting 60 for customer 202?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?
Try this:
Left click on a column in power query and choose group by.
Use these settings: