Excel and Power BI Stacking Grouped Columns Challenge @AccessAnalyticLearn

Uploaded August 2024 | Updated September 2026, 2 weeks ago

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/

👏🏻 Update - thanks to @ianrhile for suggesting a simpler approach avoiding GroupBy and utilising INTEGER DIVIDE. I've added that method to the demo file below

Demo File
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EkpLzHrrogtAoAlErGpZW_gBtrzMQdlzI8ggKg-ykWZwWw?e=7phXS8

Submit alternative solutions to info@accessanalytic.com.au

A super simple DYNAMIC ARRAY formula such as
=WRAPROWS(TOCOL(Table1,1),3) could solve this solution if it was a one off Excel only solution

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

Connect with me
wyn.bio.link

Excel and Power BI Stacking Grouped Columns Challenge

Power BI Continuous Date Hack with your own Date table

Fix Excel Spill Errors FAST With This One Formula Trick!

EXCEL LAMBDA tips (see description for link to intro video)

$What is the Power BI MCP Server? 📊Do you want to learn Power BI? Check out our amazing course at https://accessanalytic.thinkific.com/ Documentation: Overview: https://learn.microsoft.com/en-us/power-bi/developer/mcp/mcp-servers-overview Modelling MCP: https://github.com/microsoft/powerbi-modeling-mcp Claude _Desktop_Config.json { mcpServers: { powerbi-modeling-mcp: { type: stdio, command: C:MCPSERVERSPowerBIModellingMCPextensionserverpowerbi-modeling-mcp.exe, args: [ start ], env: {} } } } 🫶🏻 Join the channel to get access to perks: https://www.youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join 📗Prefer reading a book to learn then check out Power BI for the Excel Analyst by Wyn Hopkins https://pbi.guide/book/ The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/ 📊Do you want to learn Power BI? Check out our amazing course at https://accessanalytic.thinkific.com/ 📗Prefer reading a book to learn then check out Power BI for the Excel Analyst by Wyn Hopkins https://pbi.guide/book/ The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/ 00:00 Introduction 02:30 Functionality Demo 06:00 Options for Installing the MCP Server 06:40 Visual Studio Code Install 08:20 Claude Desktop Install 12:18 Recap, Final Thoughts & Shout Out$

Quick first take of the the new Fabric App