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!
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