Use Power Query to Get Top X Scores and Tie Scores

/in /by

What if you need the top 5 scores but there’s a 4-way tie for 5th? Well, we need to get all 8 people not just the top 5.

There are lots of videos showing how to extract the top X values in a list. But what about tie? This video shows how to use Power Query and consider tie scores.

You’ll see Power Query, drill down, duplicate query, and a little a little M-coding in order to get this done.

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2