How to Group By Maximum Value using Table.Max in Power Query

In this post you learn how to retrieve a value from Grouped data in Power Query. It allows you to group your data and keep valuable information that would otherwise be lost.

WRITTEN ARTICLE:

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#PowerQuery #TableMax#BIGorilla

[buttersbutters]

Thank you, I was struggling with the table concept of this, but this video helped me understand it.

[sjdaa]

Buy that gorilla a banana. Or bunches of bananas! Thank you so much for this video. I searched high/low for help with keeping data for different lines of table with revision numbers, and yours was the one that made it click! Figuring this out for my model is a great win. Thanks again.

[steveschweiger]

After re-watching I successfully got your approach to work. Thanks again.

[forestsunrise]

What I like most about this video is that it is not only short and straight to the point but also has a cool Jesus statue in the background :D Amazing content and design! Thank you very much! This channel deserves much more views!

[kebincui]

Excellent tutorial about Group By and Table.Max function; thanks for sharing

[kevinvanb.]

Dit was ontzettend handig. Mijn dank is groot!

[arnoldschwartz]

great video, clear, short, useful, and much appreciated. i'll be following you from here on, having seen some of your other videos; and please continue the good work and postings. thanks.

[TigranHayrapetyan-oyds]

Very elegant solution! Thank you for your work. Subscribed!

[LuisCarlosChavez]

Awesome!! You saved my workday! I was looking for this solution.

Thanks, finally I understood how to use this Group By with other than Sum function. Just one suggestion- maybe you could use screen magnifier to make the video more visible. You are in my notification list))

[sandracantu]

You are a genius, thank you so much for this video!

[mnowako]

Great subject! Well explained! Thank you!

[minhng]

thanks so much for sharing your knowledge!

[ExcelSwissKnife]

Very nice! Will save me a lot of time this one. So far I've always done all rows => expand => filter by [ID] = [expandedID] and [maxvalue] = [expandedvalue], but this is so much faster, thank you! :-)

[ikahmedani]

You are really champion, very well described, short and elaborative. I'm big of yours from now on.

[vashisht]

Sir Rick, if sales number(max) repeats for two different name then table.max won't return both name and product details...maybe list.max can help....but I got stuck, , ,

[jasonbuchek]

earned a sub from me homey

great video, thanks!

[ImranHussain-xvse]

Great video, it helped me to complete my assignment
Thanks for uploading video

[fajnefajne]

Hi BI Borilla, thank you for an amazing tutorial. :-)

[jameszhou]

great stuff! learnt it and used immediately