Introducing the Amazing Unpivot
Wyn Hopkins
Solving data challenges for companies and people. Power BI | Excel | Fabric | Solver Budgeting & Consolidation. Part of the Amazing team at Access Analytic Microsoft MVP ??6 Million+ YouTube views
This video showcases 2 examples of the how and why of unpivotting your data.
Every Excel and Power BI user who know about Power Query absolutely loves this feature. I can never "unpivot" without saying "BOOM!"
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.
BOOM!
Subscribe to our YouTube channel here https://www.youtube.com/c/AccessanalyticAus
Connect with me via https://wyn.bio.link/
Creating Excel solutions to take the grind out of boring and repetitive jobs giving you time to do more interesting stuff
3 年It's absolutely one of the top features of Power Query!
Microsoft MVP/Formador en Analisis de Datos/Consultor BI/MOS Excel Expert/Microsoft Certified Trainer/Diplomado en NIIF
3 年The best feature of the best Tool!!!... ????
Data & Analytics Professional | Microsoft Data Platform (Power BI) and M365 (Excel) MVP
3 年Such well explained examples! Thanks again for everything you’re doing for the community Wyn! I would add, though, something on the second example, something I’ve learned from Ken Puls and Matt Allington : hide the Dimension Keys from the two fact tables so that the end user is not “tempted” to use them in the visuals and only use the Dim tables for slicing ??