Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you both!
@mahoneypat is right!
Since you are new I am sharing this video https://www.youtube.com/watch?v=W6UeZCte9YM
Thanks,
Ritesh
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
41 | |
23 | |
21 | |
21 | |
13 |