Power Query - Alternate Group By Strategies

[@sujirpinna]

Your videos are very unique and your illustrations are to the point . You address complex requirements with ease . Very skilful indeed !

[@bcti-bcti]

Thank you!!!! We appreciate you taking the time to watch.

[@GuillermoPalchik]

It's so funny-every time you release a new PowerQuery video, it feels like Christmas! Keep up the amazing work

[@bcti-bcti]

Oh, if I could only make it a daily thing for you. But then you'd probably get sick of it. Thanks for your encouraging words.

[@excel_along_the_way]

You wanted to know how cool this video was, I would say the heat is on. One of the best explanation I have seen on this feature of GroupBy.

[@bcti-bcti]

Thank you for the positive critique!

[@MattHarris3]

Agree with the comments, you really have some great focussed content - keep up the good work!

[@kebincui]

Brilliant as always 👍👍. Thank you very much.

[@boissierepascal5755]

🇨🇵 vert instructive, clear and powerful. I liké the way you teach. Thanks a lot for your precious work 🙏🏽

[@bcti-bcti]

Thank YOU for watching and commenting.

[@IvanCortinas_ES]

Excellent tutorial. As always, going deeper to add a lot of value to the content!! Thank you.

[@bcti-bcti]

Glad to hear you enjoyed the video. 👍👍

[@bimanroy3041]

Superb! Your voice quality is the best

[@bcti-bcti]

Awwww, thanks ☺

[@MaureenPesch]

Never knew about this- thank you!!!

[@bcti-bcti]

You are most welcome. Thanks for watching.

[@GosCee]

These are next-level tips and tricks, indeed! Powerful! Thank you.

[@bcti-bcti]

Thanks. I learned from The Best.

[@sdr5593]

Excellent, I have not seen this anywhere else. You deserve way more subs.

[@bcti-bcti]

We’re still a young channel, but with your kind support we’ll grow to be like the Big Guys. 👍🏼

[@LeeBingaman]

Very cool! I've been looking for this kind of option with grouping.

[@bcti-bcti]

So glad to hear that we were able to help you with your need. Thanks for watching.

[@iankr]

Useful techniques & clear explanation. Thank you very much!

[@bcti-bcti]

Thank YOU!!!

[@baskis69]

Thank you for such a detailed explanation, I didn't know the GroupKind parameter... very useful!

[@bcti-bcti]

You are most welcome. I'm glad you found it useful. I'm a fan of it as well. Thanks for watching.

[@FsoOmar]

Absolutely 💯 brilliant 👏. This video is a treasure.

[@bcti-bcti]

So nice of you to say. 😊. Thanks for taking the time to watch.

[@AliHasan-pb8cu]

Excellent

[@bcti-bcti]

Thank you for taking the time to watch and comment.

[@ExcelWithChris]

Brilliant stuff. Great explanation - keeping it simple and focusing on the stuff we want to use and need every day. Not all those complicate DAX code. I know they are helpful, but mostly the everyday user wants to do something simple, but just need that extra step here and there. Great job!!

[@bcti-bcti]

Thanks! I agree: the DAX stuff is super cool, but most users like to keep it simple. Thanks for watching.

[@user-mma173]

I just came across your channel. Very useful and well explained tutorials. Thanks

[@bcti-bcti]

Thank YOU. We appreciate your time.

[@olipeeeeee]

🙏 very helpful. I'll use this to analyse frequency data for retail stores. Thanks for your great explanations. As always a pleasure.

[@bcti-bcti]

Glad to hear it will help you in the Real World!! Awesome!

[@v2pumo817]

Thanks for clear explanation.

[@bcti-bcti]

You are quite welcome. Thank you for watching.

[@noneyabeezwax8865]

Yes! I can use this. Very very cool!

[@ابوالايهمالصادق]

ماشاء الله تبارك الله شرح جميل جدا جدا ( الله يهديك أستاذي العزيز ويشرح صدرك لمعرفة الحقيقة )

[@bcti-bcti]

شكرا جزيلا لكلماتك اللطيفة. وأنا أقدر كثيرا نسبة المشاهدة الخاصة بك.

[@TheSardOz]

Great tutorial.

[@bcti-bcti]

Thanks!!!

[@nickynicku9795]

Thank you so much!

[@bcti-bcti]

Our pleasure. Thanks for watching 👍🏼👍🏼

[@92monish]

Superb Video

[@bcti-bcti]

Thank you. That’s very kind of you to say. Thanks for watching.

[@kafikhan4064]

Great.... Thanks a lot......

[@bcti-bcti]

Our pleasure. Thank YOU for taking the time to watch.

[@Sleette]

Coming from a Python/Pandas etc. background, trying to learn the Power Query/Power BI world for work. Have watched many KZbin videos and yours are consistently among the best: very well explained, good real-world-ish examples. Keep up the good work! Small issue with the accompanying files for this video, the Original Data ("Data") table in the Casing Test workbook doesn't have any alternate casings. Minor oversight.

[@bcti-bcti]

Thanks for the kind words, and for catching the file glitch. I'll look into it immediately.

[@bcti-bcti]

The download file has been corrected. Darn; I hate when that happens. Thanks for catching that so I don't look The Fool.

[@petercompton538]

Oustanding!

[@bcti-bcti]

@@petercompton538 Thanks!

[@juliannavas9561]

8:12 How would you do this in pandas?

[@bcti-bcti]

@@juliannavas9561 Sorry, but I have no idea. That’s an area I have no experience in. Perhaps some nice viewer might know and come save the day. Thanks for watching.

[@tinhoyhu]

Tanks for the great video I such a useful feature. Trying to do it without groupkind would've been so cumbersome. BTW, what cam groupkind.type be used for?

[@bcti-bcti]

Agreed. The "Global" method is vastly more common in practice, but it's nice to know the "Local" method for unique scenarios.