⏬ 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...



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/