Forum Discussion

EaglesTony's avatar
EaglesTony
Post Prodigy
3 years ago
Solved

How do I group multiple columns ?

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,

  • EaglesTony's avatar
    EaglesTony
    3 years ago

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

2 Replies