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
[ Ссылка ]
Connect with me
[ Ссылка ]
Access Analytic blog: [ Ссылка ]
