Forum Discussion

smko's avatar
smko
Helper I
5 years ago
Solved

Pivoting in PQ

Original Table Date ID Qty Volume 1/1/2021 1 50 1000 1/1/2021 2 70 2000 2/1/2021 1 40 800 2/1/2021 2 60 1500 2/1/2021 3 10 200   First expected result (by qt...
Need Help
  • Mohammad_Refaei's avatar
    Mohammad_Refaei
    5 years ago

    If you don't want to write long M Queries then you can follow simple steps with the Power Query GUI.

    The fisrt table is already created so I won't highlight it.

    For the second one, you may select both Qty & Volume columns and in Power Query go to Transform --> Unpivot.

    Select your date column and change it to Text

    Then Select the Date and Attribute columns, right click any of them then Merge Columns them

    Then Pivot the Merged column on the value field

     

Mohammad_Refaei's avatar
Mohammad_Refaei
Solution Specialist
5 years ago

If you don't want to write long M Queries then you can follow simple steps with the Power Query GUI.

The fisrt table is already created so I won't highlight it.

For the second one, you may select both Qty & Volume columns and in Power Query go to Transform --> Unpivot.

Select your date column and change it to Text

Then Select the Date and Attribute columns, right click any of them then Merge Columns them

Then Pivot the Merged column on the value field

 

smko's avatar
smko
Helper I
5 years ago

Wow this is some voodoo magic right there, thanks!