Forum Discussion

Anonymous's avatar
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 ...
  • Anonymous's avatar
    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.

v-yulgu-msft's avatar
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's avatar
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.