Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Nested Group By

Hello PowerBI experts,

I need some help with a situation.

I have a datasource that is looking like this.

I try to do a nested group by and have an output like :

Red

Line 1

Line 3

total

Green

Line1

Line4

total

Blue

Line2

total

Can you give me some hints how to accomplish this ?

Thank you.

Anonymous
8 years ago
I find an workarround.
I did 3 copies of the querry.
To first I renamed column A to SalesPerson, to second I renamed column B to SalesPerson to third querry I renamed column C as SalesPerson.
Then I combined this 3 queries to one and I have a common column, SalesPerson.

Maybe there a better solution. Time to load data is increased with this method.

4 Replies

v-yulgu-msft
Microsoft Employee
8 years ago
Hi Anonymous,

I cannot understand your requirement very well. What does "Line1", "Line3" refer to? Could you please describe the desired output with more details? If possible, please show your desired result with an image.

Regards,

Yuliana Gu
- Anonymous
  Not applicable
  8 years ago
  I need a grouping by sales person. But sales person can be on one of first 3 columns.
  Sales person Red is on first line and third line. and so on.
  I think a method is to unpivot table.
Anonymous
Not applicable
8 years ago
Solution what I found is to make 3 copies of the query source.
Unpivot each copy table bt column A, column B and column C to a common column SalesPerson and merge them after.
Anonymous
Not applicable
8 years ago
I find an workarround.
I did 3 copies of the querry.
To first I renamed column A to SalesPerson, to second I renamed column B to SalesPerson to third querry I renamed column C as SalesPerson.
Then I combined this 3 queries to one and I have a common column, SalesPerson.

Maybe there a better solution. Time to load data is increased with this method.