Forum Discussion

AnonymeC's avatar
AnonymeC
Regular Visitor
3 years ago
Solved

Equivalent to "Group By" function on multiple columns?

Hello,   I have a huge database that basically looks like:   Code Market Factory Jul 21 Aug 21 Sep 21 .... Apr 23 May 23 Jun 23 3424555332 DACH XXX 0 34 24 ... 22 50 12 ...
Need Help
  • slorin's avatar
    slorin
    3 years ago

    Hi

    UnPivot then pivot

    let
    Source = YourSource,
    UnPivot = Table.UnpivotOtherColumns(Source, {"Code", "Market", "Factory"}, "Attribute", "Value"),
    Pivot = Table.Pivot(UnPivot, List.Distinct(UnPivot[Attribute]), "Attribute", "Value", List.Sum)
    in
    Pivot

    Stéphane 

slorin's avatar
slorin
Super User
3 years ago

Hi

UnPivot then pivot

let
Source = YourSource,
UnPivot = Table.UnpivotOtherColumns(Source, {"Code", "Market", "Factory"}, "Attribute", "Value"),
Pivot = Table.Pivot(UnPivot, List.Distinct(UnPivot[Attribute]), "Attribute", "Value", List.Sum)
in
Pivot

Stéphane 

AnonymeC's avatar
AnonymeC
Regular Visitor
3 years ago

Thank you it worked perfectly.