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
OSS's avatar
OSS
Icon for Helper III rankHelper III
7 years ago

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'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