Forum Discussion

OSS's avatar
OSS
Icon for Helper III rankHelper III
7 years ago

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...
Need Help
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

Try this: 

Left click on a column in power query and choose group by. 

Use these settings:

OSS's avatar
OSS
Icon for Helper III rankHelper III
7 years ago

This is also doesn't work :(  We have already discussed this issue in the previous message