Advanced Grouping Tricks In Power Query

In this video, we will learn Advanced Grouping Tricks in Power Query. If you've ever used the grouping option in the transform tab of Power Query, you know the basics. But in this tutorial, we take it a step further and reveal some mind-blowing tricks that will enhance your data manipulation skills.

===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -

✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step-by-Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!

[ajinkyashinde]

You are the boss of power query transformation 💪 ❤️❤️

[alexbarbucristi]

The first time that I can say "I already knew all"

Thank you so much for all your videos, you are the best at Power Query.

The only thing I would do differently is for the last trick I would create 2 columns one with minimum date and one with maximum date and then extract the days to ensure I capture the exact period.

[BicycleFriends]

I love the "Grouped Rows" and Totals example.

[carlosdias]

Thanks for the video. Blown away since i always assumed Powerquery was linear and sequencial, suddenly seeing you calling early steps blew my mind.

Also the flexibility of the group by is quite amazing, i was not aware.

Super useful stuff to use on Dataflows.

[anillpatel]

Excellent Presentation.
Very useful Grouping techniques.

[sarveshdeshpande]

I am speechless to what i saw …. Group kind local was mind blowing 😮
I recently worked on one such scenario, i wish this video should have came up earlier. But no worries thanks Chandeep for this wonderful trick and i will correct my data logic now and make it bit simple ❤

[Hello-bnyc]

Man you are just Blessed by God in Power Query...

[jimgleason]

Chandeep, you are absolutely the best. These are brilliant tricks.

[maciejkaron]

This concatenation example is mind blowing for me. I will definetely use it in my future projects. Great video!

[hilaryb]

You’re the only one who explains M code in a way I can understand it and I desperately needed this video last week, my guy lol. I had to do grouped running totals and everyone else does it by using a custom function. I attempted the custom function until I felt like my brain was melting but I finally got it to work. Seeing your last solution, which was exactly what I needed, is so simple I could cry 😂 For a spreadsheet that uses sources with 100, 000+ rows, is this way more efficient than the custom function?

[oscarmendez-roca]

Great and very useful set of tricks, thanks a lot Chandeep!

[shubhabratadey]

You are a weird GENIUS who keeps us amazing in every videos...😄
Please keep on sharing such Learnings

[eslamfahmy]

Perfect goodly as usual but i think we can use Table.Column functuin to get the concatenated result in Exp1, in the meatime ur solution is the best 😊

[karimallahwala]

Great content and very helpful. I can‘t choose the Most helpful one. They are all very very good.Thank you so much

[shashipaul]

So awesome.... I'm going to use 1st n 3rd ....

[FsoOmar]

Awesome tricks! All of them are mind-blowing and new to me. Thanks a lot for your fantastic tutorials.

[dharmmu]

You are just playing with power query like a pro

[AnbarasuAnnamalai]

I loved all the examples, particularly the Text. Combine grouping. Can a delimiter like CHAR(10) be used here to keep texts in a separate line?

[rosicalp]

Awesome and helpful as usual ! Thanks a lot!
I'm already planning to do some optimizations with the append trick.

[captvo]

Amazing and productive tricks! Thank you!