Рет қаралды 42,553
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 /...
Connect with me
wyn.bio.link/
Access Analytic blog: accessanalytic.com.au/blog/