How and why to Unpivot data with Power Query

This video showcases 2 examples of when you need to unpivot your data. The first scenario is a simple unpivotting exercise using just Excel In the second scenario I use Power BI and work around one of the issues that unpivotting may cause. 00:00 Intro 00:26 Basic Example 04:39 More Complex Example requiring Table split and Dimension Table creation Link to video on the Calendar Table    • What is a Date Table / Calendar table...   Connect with me wyn.bio.link/ Access Analytic blog: accessanalytic.com.au/blog/