Power Query Multi Column Data - Best In Class Challenge

⏬ Links below ⏬
Here's the original challenge
https://accessanalytic.com.au/power-q...

Here's the link to everyone's submissions and a solution file
https://aasolutions.sharepoint.com/:f...

00:00 Intro
00:37 The Problem
01:50 Setting the data range (using Print Area?)
03:29 Extracting a Date and Filling Down
07:27 Filter a column for any date value
08:31 Custom Column Reference and Fill down
10:15 The Unpivot Other Columns Technique
10:30 Merging a Query with itself
12:30 GroupBy to get the person with the highest average each day
15:49 Testing with some new data


The Power Query Challenge Playlist Power Query Challenges

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/
https://accessanalytic.com.au/