Add index to nested tables in Power Query

In today's video, I am going to show you how to add individual indexes to groups in power query using the M language. #powerquery #powerbi #curbal

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

[shdwink]

Just commenting to say that 5 years later you just saved me a TON of time with this video. I've been wracking my brain trying to figure out a way to effective rank a price list based on part # and still return the ancillary data (item description, vendor, manufacturer, etc.). This solves my problem perfectly.

THANK YOU!

[davida.taylor]

This is fantastic and solves my problem; exactly what I needed. Thanks for posting this 5 years ago! And, I keep learning tricks like this along the way.

[christinerbion]

You nailed this lesson Ruth. I love that you explain functions and acknowledge the importance of understanding how they work and why. As a user I appreciate your ability to teach and not just show viewers how to copy you. Understanding leads to growth. Thanks!!

[christinerbion]

You nailed this lesson Ruth. I love that you explain things and acknowledge the importance of understanding how functions work and why. As a user I appreciate your ability to teach and not just show viewers how to copy you. Understanding leads to growth. Thx!

[m.raedallulu]

I found your channel nearly a week ago, and after (5 seconds) of watching you I quickly realized that you are amazingly genius person.. and I was right as usual 😎

[alexkim]

This is wonderful, Ruth. Thank you so much for sharing. I suppose you just helped us all to up our M game.

[vandrecarlos]

You're like some kind of witch or something?! I've learned more from your videos then from any other videos from creators in Brazil! Thanks a lot! Love your channel!

[denpries]

@Ruth, I have a nice addition to this trick i think. I was using it to get the subgroup index for a key, but this index had to be sorted differently.
If you do a normal indexing operation you will see it uses your sorted table. Sorting the other way around basically changes the index process.
However, the intermediate grouping cancels this and it will resort based on the columns left to right. In order to fix this: put the column you want to sort on at the far left end of your table, and then sort it, group it, and do the trick as explained. Using this method you can sub-index groups the other way around :)

[Gustavo-Santana]

Your videos are just wonderful, thank you very much Ruth, greetings from Brazil!

[BenoitDecoster]

This solution is THE solution I was looking for - for days. Very usefull Ruth. Thank you so much. You made my day.

[tgammell]

This was SO helpful, I've been pulling my hair out for days trying to figure out how to optimize a report I'm fixing, and couldn't figure out a way to create custom columns without creating a duplicate table that i can group. Thank you!

[S.cgb_]

Your videos are the best!! You have helped me so much. Now when I have a problem I cannot solve I search in your channel and you always have the answers :)

[Rrabbit_swim]

Amazing! Such a good channel for PBI resources! Thank you Ruth

[fieryzou]

Thank you so much for your trick. I have been trying to add the index for a group. Finally I found the solution. 😊

[ofthesanes]

Thank you!...these are tips that takes one's learning to the next level!

[mikem]

I don't know how you do it, but all the time when I am searching for a solution to specific issues, I almost always find it in your videos.
You're incredible! ❤❤❤

[johannlotter]

This is brilliant thanks so much.
I actually used this same trick to add index to the records from a file when combining files from folders.
When you combine multiple files from a folder and you want the index per file instead index by full data set.

Brilliant thanks.

[zachehmann]

Your videos have been a huge help as I've just started learning. Thank you!!

[mwaltercpa]

PQ magic! Thanks Ruth.. that was perfect!

[adambaker]

Really helped me out there with that trick for a work report, thanks alot👍😊