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...
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?
Try this:
Left click on a column in power query and choose group by.
Use these settings: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?
This is also doesn't work :( We have already discussed this issue in the previous message
