Pivoting and Unpivoting

Real-world data often arrives in formats that Power BI can't use directly. A common example is spreadsheets with months spread across columns instead of listed down rows. In this chapter, you'll learn how to reshape data using Power Query's pivot and unpivot features.

You'll transform the Summit Gear monthly targets file from a wide format (one column per month) into a tall format (one row per region, per year, per month) that Power BI can work with. You'll learn the difference between pivoting and unpivoting, as well as when to use each.