Pivot/Unpivot Options in Power Query
This is part of an unpivot variation series, which is all about turning your data into a proper tabular format that is suitable for analysis.
Trusted by 220,000+ people worldwide.
How to unpivot multiple column combinations without using any of the Power BI Unpivot Columns commands that are accessible on the ribbon. Here I used List.Zip to unpivot sets of data in Power Query.
I recommend that you explore more of this function and implement it in your own Power BI reports.
What our
Students Say
Curriculum
Pivot/Unpivot Options in Power Query
Your
Instructor
Melissa de Korte
Enterprise DNA Expert
- Skilled in ETL and Modelling. Delivered practical Power Query solutions in both Excel and Power BI.
- Expertise in analysing business process data. Delivering, deploying and supporting Power BI solutions throughout the organisation.
- All-round Power platform enthusiast.
Frequently Asked
Questions
What’s the difference between a free account and a paid plan?
Do I need to know anything about data science or data analytics to get started with Enterprise DNA?
How will I be charged?
Can I get an invoice for my company?
Are refunds available?
Will AI take over the world and make data skills worthless?
Recommended
Courses
Integration, Analytics, and Governance for MS Fabric
Data Management and Processing in Microsoft Fabric
Foundations of Microsoft Fabric
Get full access to unparalleled
training & skill-building resources
FOR INDIVIDUALS
Enterprise DNA
For Individuals
Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.
Learn MoreFOR BUSINESS
Enterprise DNA
For Business
Training, tools, and guidance to unify and upskill the data analysts in your workplace.
Learn More