Uploaded July 2024 | Updated September 2026, 2 weeks ago

---

⏬Link to file
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EpHe1zDrYztIrrEtS20U7wsB0FAdpBu4ydV_flZvnn8YVA?e=RetJoU

00:00 Intro
01:28 The Topics Covered
03:37 Index Column And GroupBy
05:30 Adding Counter inside Group
07:20 MODULO
09:47 INTEGER DIVIDE
11:54 Load to the Data Model
12:39 Insert Pivot Table
14:00 Setting up Pivot Table and adding Name
14:24 Using CONCATENATEX to display Text in Values
16:38 Adding an input Parameter avoiding formula firewall


Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/

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/
Connect with me
wyn.bio.link