Uploaded April 2023 | Updated November 2026, 3 hours ago
Unpivoting is an extremely valuable feature of Power Query. It can take report style data and turn it into usable tabular format. In this video, let me introduce Unpivot with two practical examples.
Download the sample data file from here - chandoo.org/wp/wp-content/uploads/2023/04/unpivot-example.xlsx
WATCH NEXT:
Budget vs. Actual Variance Analysis with Power BI - youtu.be/8tfcVnoEL0c
MORE ON POWER QUERY:
π₯Learn Power Query essentials in 1 hour - chandoo.org/wp/power-query-power-course
Power Query - Basics: youtu.be/UAFExySaSPY
Power Query - Deep introduction: youtu.be/PiFAa_jjaEI
Power Query - 5 Advanced Examples: youtu.be/yJum0g4qM2c
10 Timesaving tricks with Power Query: youtu.be/t43kb7BRsFY
Power Query vs. Power Pivot vs. Power BI: youtu.be/6lzdovy1uCw
~
In this video:
0:00 - Unpivot, why we need it?
0:27 - Trick 1: Unpivot budget data
2:58 - Trick 2: Unpivoting two-level data
4:29 - Budget vs. Actual Variance Analysis
~
What does the baker do half way thru baking the bread?
She BUNPIVOTS π
Unpivoting is an extremely valuable feature of Power Query. It can take report style data and turn it into usable tabular format. In this video, let me introduce Unpivot with two practical examples.
Download the sample data file from here - chandoo.org/wp/wp-content/uploads/2023/04/unpivot-example.xlsx
WATCH NEXT:
Budget vs. Actual Variance Analysis with Power BI - youtu.be/8tfcVnoEL0c
MORE ON POWER QUERY:
π₯Learn Power Query essentials in 1 hour - chandoo.org/wp/power-query-power-course
Power Query - Basics: youtu.be/UAFExySaSPY
Power Query - Deep introduction: youtu.be/PiFAa_jjaEI
Power Query - 5 Advanced Examples: youtu.be/yJum0g4qM2c
10 Timesaving tricks with Power Query: youtu.be/t43kb7BRsFY
Power Query vs. Power Pivot vs. Power BI: youtu.be/6lzdovy1uCw
~
In this video:
0:00 - Unpivot, why we need it?
0:27 - Trick 1: Unpivot budget data
2:58 - Trick 2: Unpivoting two-level data
4:29 - Budget vs. Actual Variance Analysis
~
What does the baker do half way thru baking the bread?
She BUNPIVOTS π










