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.

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