Forum Discussion

sabd80's avatar
sabd80
Helper IV
1 year ago
Solved

Power Query pivot

Hi, I have below data in Power BI:   I would like to pivot the data to below in another table:   How can I do that?
  • govind_021's avatar
    1 year ago

    Hi , sabd80 
    Please , follow below steps
    1) Select Volume , Gross Value , Net Value column with help of ctrl key 
    then go to "Transform" and select unpivot columns then Unpivot only Selected columns 

    then your data will look like this 

    2) After That select source and  attribute column with ctrl key together and go to trasnform and select
    merge columns and in separator choose space from the option.


    Then your data will look like this 

    3)  After that select Newly merged column

    and click on Transform data "Pivot" and in value section select Value column
    and your data will be in desired state 

     

    Best Regards,
    Govind Sapkade
    Data Analyst | Power BI Enthusiast | Microsoft PL 300 Certified Power BI Data Analyst | MS Fabric Enthusiast
    🎥Subscribe to my youtube channel for hands on tutorials : YouTube

    📊Let’s connect on Linkdin : Linkdin