by Wyn Hopkins

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!

*Don’t forget to make your solution flexible so that if more rows or columns are added your solution still works!

Download the file

Sending us your solutions

If you would like to submit your solution please save your file as:

Your Name – Power Query Challenge – Best in class.xlsx (or PBIX if using Power BI) and send to info@accessanalytic.com.au

Please don’t send just M code.

We’ll add your submission to our submissions folder here.

Keep an eye out for Wyn’s solution on our YouTube channel.