Group Uniques - Power Query Challenge @AccessAnalyticLearn

Uploaded November 2023 | Updated September 2026, 2 weeks ago

⏬ This Power Query Challenge is about combining multiple records into single rows ⏬

00:00 Intro
00:19 The Challenge
01:44 The Long Solution
05:44 The Better Solution

The Solution File and everyone's submissions can be found here:
aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/ErJaOpJKIm1NhjPENOyiDwABX1sGPwcJWcq0EuSZelx5kA?e=BYyE7P

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

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

Pretty charts don’t help if the answers are buried

The Fastest Replace Values method using a list in Power Query

Power BI Org Apps are now generally available in PRO workspaces with Audiences feature

Excel GROUPBY and PIVOTBY plus checkboxes - October 2024 update part 1