Max Date Value in Power Query – Power Query Challenge

Hola People!

I thought of posting another interesting and common problem as a challenge but this time it’s on Power Query!

 

Consider this Data

We have Students who attempted a test on multiple dates. Note that a student can take the test twice on the same date.

 

The Problem

You have to transform the above data using Power Query so that you get a table with 3 columns..

• Name
• Latest Attempt Date
• Score on Latest Attempt Date

A little twist, if the student attempted the test twice you should get both scores 😉

Here is how the output should look like

 

Only one Rule – Use Power Query and nothing else and post your answers in the comments, preferably with a link to download your solution.

DOWNLOAD DATA

 

I’ll post my solution on Friday, 16 Oct. Get Going!

Cheers

– – –

 

Solution Video

 

DOWNLOAD ALL SOLUTIONS FROM BELOW

 

More matter for your Mind!

1. SUMX Problem – DAX
2. New Subscribers – DAX Challenge
3. Separate Managers from Employee Names – Power Query
4. Unique Dates Challenge
5. Commission Accrued Challenge