Dec 22, 2022 2:00 PM

Power Query Multi Column Data - Best In Class Challenge

External YouTube Channel

School’s almost out for summer (well in Australia anyway)… how has everyone done in their exams?

The Challenge…

School’s almost out for summer (well in Australia anyway)… how has everyone done in their exams? Who had the highest average score for each day?

How can we tell? We need to sprinkle on some Power Query Magic dust!

In this Video

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