Excel Text in Pivots and Power Query Magic

⏬Link to file
https://aasolutions.sharepoint.com/:f...

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
https://wyn.bio.link/