How do I group multiple columns ?

[EaglesTony]

Hi,

  I have the following data:

Project: 123

Order: 22-1

Amt: 100

Project: 123

Order: 22-1

Amt: 200

Project: 123

Order: 22-2

Amt: 30

Project: 456

Order: 22-1

Amt: 500

Project: 456

Order: 22-1

Amt: 400

I need my data grouped by this so I can get something like this:

Project: 123 Order: 22-1 Amt: 300

Project: 123 Order: 22-2 Amt: 30

Project: 456 Order: 22-1 Amt: 900

Does this involve either multiple grouping in 1 Power M step or multiple steps ?

Thanks,

[Idrissshatila]

Hello @EaglesTony ,

You could append all the tables in one table.

https://learn.microsoft.com/en-us/power-query/append-queries

If I answered your question, please mark my post as solution, Appreciate your Kudos  👍

Follow me on Linkedin

[EaglesTony · Accepted solution]

I ended up grouping by Project and Order with a Sum on Amt and this gave me the results I needed, but thank you.