Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Pivot/Unpivot Power Query

Hello I have my source in a similar format as the picture below; The format that I want to switch this to is have the months in one column and have 2 seperate columns for 2018 and 2019 sales. ...
Need Help
v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi,

 

You can unpivot the column 2018 1 sales - 2019 12 sales to row data like picture below. Renamed the new column .Or could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

 

For example:

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you for the help,

    Yeah I realized I wasn't very clear with my question.  Basically I have different monthly data in columns like 2018 Jan sales, 2018 Feb sales, ... 2019 Jan sales, 2019 Feb sales, ... and I wanna have the months in one column and have 2 columns for 2018 sales and 2019 sales like this;

    I tried to unpivot the first 12 column and then the other 12 column but it doesnt work.

     

    Thanks again