Resources

An INDEX MATCH challenge with Power Query M

Let’s create your free account

Google

Microsoft

If you have an account Login here

Here’s your challenge should you choose to accept it. Starting with a 3 column wide table, each column contains numbers (that needs no validation). The task is to add columns that return the column name for the column with the Min and Max value on each row. There are no rules for dealing with multiple matching values, at least one value should be returned per row.

Here’s the sample data, just copy and paste into a new blank query.

let

Source = Table.FromColumns(

{

{55, 48, 36, 26, 93, 27, 3, 67, 36, 27, 50, 69, 80, 44, 5},

{76, 46, 73, 17, 99, 40, 35, 2, 29, 41, 15, 20, 22, 28, 5},

{79, 55, 42, 83, 13, 50, 87, 18, 16, 11, 44, 43, 3, 28, 5}

}, type table [ Charlie=number, Bravo=number, Alpha=number]

)

Source

Check the resource to learn how to solve this!

An INDEX MATCH challenge with Power Query M Cover

Download

What our Students Say

Your Author

EDNA Team

Data & AI

At Enterprise DNA, we're more than just an online platform—we're your partner in advancing your data analytics and artificial intelligence capabilities. Our mission is to equip you with the tools to future-proof your career through mastery of data skills and upskilling in AI. We tailor training pathways to fit your unique learning journey and provide live data exercises and challenges to build hands-on experience. Together, we transform data into knowledge and skills into success.