Solved: Pivoting Daily Data

AndrewB · ‎08-29-2022

Hi all,

This seems like it should be fairly basic but I am just starting out with Power Query. I'm attempting to transform my data from top format into bottom format. Could anybody please advise best way to do this?

Regards,

Andrew

mahoneypat · ‎08-29-2022

In the query editor, select your first column, then right click and choose Unpivot Other Columns. This will create your desired format with "Attribute" and "Value" columns you can rename (or update the names in the unpivot step).

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

AndrewB · ‎08-29-2022

Thank you both!

ribisht17 · ‎08-29-2022

@AndrewB

@mahoneypat is right!

Since you are new I am sharing this video https://www.youtube.com/watch?v=W6UeZCte9YM

Thanks,

Ritesh

mahoneypat · ‎08-29-2022

In the query editor, select your first column, then right click and choose Unpivot Other Columns. This will create your desired format with "Attribute" and "Value" columns you can rename (or update the names in the unpivot step).

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube