⏬ Click to see more:
If you ever need to Pivot your data it's quite possible you've hit an error.
Here I explain why, and how to avoid it
00:00 The Intro
00:17 The Setup
01:20 Getting the Error
02:15 Why the error?
02:56 The solution
03:11 Group By
03:56 Add an Index column within the group
05:32 The Pivot now works!
05:55 BONUS PRO TIP: Merging the Query with itself 🤯
File to download:
https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/ErfySeOogsZPsWNbaxEFEKwBUdGBxiZq0w5R0Wv64Xkt3g?e=KlqZdm
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/