Power Query - Alternate Group By Strategies
Рет қаралды 2,249
15 күн бұрынExplore the largely unknown controls in Power Query's Group By feature to perform groupings that are thought to be impossible. See how simple it is.
Also, see how you can make your grouping case-insensitive; also useful when performing FIND and LOOKUP operations.
File Download Link:
www.bcti.com//wp-content/YT_D...
00:27 Table.Group Arguments List
01:11 Group By - Using Mandatory Arguments Only
01:41 Group By - Using Optional Arguments
03:33 Temperature Category Change (Example)
05:11 Losing the Gear Icon
06:35 Restoring the "Lost" Gear Icon (GUI Options)
08:15 Creating Additional Calculations
09:13 Grouping withOUT case-sensitivity
11:14 Bonus Features (in the File Download)
11:56 Conclusion
@sujirpinna 13 күн бұрын
Your videos are very unique and your illustrations are to the point . You address complex requirements with ease . Very skilful indeed !
@bcti-bcti 13 күн бұрын
Thank you!!!! We appreciate you taking the time to watch.
@GuillermoPalchik 12 күн бұрын
It's so funny-every time you release a new PowerQuery video, it feels like Christmas! Keep up the amazing work
@bcti-bcti 8 күн бұрын
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.
@lesterpotts6142 13 күн бұрын
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 13 күн бұрын
Thank you for the positive critique!
@MattHarris3 10 күн бұрын
Agree with the comments, you really have some great focussed content - keep up the good work!
@IvanCortinas_ES 13 күн бұрын
Excellent tutorial. As always, going deeper to add a lot of value to the content!! Thank you.
@bcti-bcti 13 күн бұрын
Glad to hear you enjoyed the video. 👍👍
@iankr 11 күн бұрын
Useful techniques & clear explanation. Thank you very much!
@bcti-bcti 11 күн бұрын
Thank YOU!!!
@sdr5593 13 күн бұрын
Excellent, I have not seen this anywhere else. You deserve way more subs.
@bcti-bcti 13 күн бұрын
We’re still a young channel, but with your kind support we’ll grow to be like the Big Guys. 👍🏼
@kebincui 13 күн бұрын
Brilliant as always 👍👍. Thank you very much.
@boissierepascal5755 13 күн бұрын
🇨🇵 vert instructive, clear and powerful. I liké the way you teach. Thanks a lot for your precious work 🙏🏽
@bcti-bcti 13 күн бұрын
Thank YOU for watching and commenting.
@baskis69 12 күн бұрын
Thank you for such a detailed explanation, I didn't know the GroupKind parameter... very useful!
@bcti-bcti 12 күн бұрын
You are most welcome. I'm glad you found it useful. I'm a fan of it as well. Thanks for watching.
@AliHasan-pb8cu 13 күн бұрын
Excellent
@bcti-bcti 13 күн бұрын
Thank you for taking the time to watch and comment.
@user-mma173 12 күн бұрын
I just came across your channel. Very useful and well explained tutorials. Thanks
@bcti-bcti 12 күн бұрын
Thank YOU. We appreciate your time.
@ExcelWithChris 13 күн бұрын
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 13 күн бұрын
Thanks! I agree: the DAX stuff is super cool, but most users like to keep it simple. Thanks for watching.
@LeeBingaman 12 күн бұрын
Very cool! I've been looking for this kind of option with grouping.
@bcti-bcti 8 күн бұрын
So glad to hear that we were able to help you with your need. Thanks for watching.
@SndfOmar 13 күн бұрын
Absolutely 💯 brilliant 👏. This video is a treasure.
@bcti-bcti 13 күн бұрын
So nice of you to say. 😊. Thanks for taking the time to watch.
@olipeeeeee 12 күн бұрын
🙏 very helpful. I'll use this to analyse frequency data for retail stores. Thanks for your great explanations. As always a pleasure.
@bcti-bcti 8 күн бұрын
Glad to hear it will help you in the Real World!! Awesome!
@bimanroy3041 13 күн бұрын
Superb! Your voice quality is the best
@bcti-bcti 13 күн бұрын
Awwww, thanks ☺
@v2pumo817 13 күн бұрын
Thanks for clear explanation.
@bcti-bcti 8 күн бұрын
You are quite welcome. Thank you for watching.
@user-tg1vt5tw8c 13 күн бұрын
ماشاء الله تبارك الله شرح جميل جدا جدا ( الله يهديك أستاذي العزيز ويشرح صدرك لمعرفة الحقيقة )
@bcti-bcti 13 күн бұрын
شكرا جزيلا لكلماتك اللطيفة. وأنا أقدر كثيرا نسبة المشاهدة الخاصة بك.
@TheSardOz 13 күн бұрын
Great tutorial.
@bcti-bcti 13 күн бұрын
Thanks!!!
@nickynicku9795 13 күн бұрын
Thank you so much!
@bcti-bcti 13 күн бұрын
Our pleasure. Thanks for watching 👍🏼👍🏼
@kafikhan4064 12 күн бұрын
Great.... Thanks a lot......
@bcti-bcti 8 күн бұрын
Our pleasure. Thank YOU for taking the time to watch.
@92monish 12 күн бұрын
Superb Video
@bcti-bcti 12 күн бұрын
Thank you. That’s very kind of you to say. Thanks for watching.
@Sleette 13 күн бұрын
Coming from a Python/Pandas etc. background, trying to learn the Power Query/Power BI world for work. Have watched many KZfaq 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 13 күн бұрын
Thanks for the kind words, and for catching the file glitch. I'll look into it immediately.
@bcti-bcti 13 күн бұрын
The download file has been corrected. Darn; I hate when that happens. Thanks for catching that so I don't look The Fool.
@tinhoyhu 13 күн бұрын
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 13 күн бұрын
Agreed. The "Global" method is vastly more common in practice, but it's nice to know the "Local" method for unique scenarios.
Marat Oralgazin
Рет қаралды 443 М.
Go Gizmo!
Рет қаралды 27 МЛН
BCTI
Рет қаралды 2,9 М.
Excel Off The Grid
Рет қаралды 17 М.
Infinity Circus
Рет қаралды 10 МЛН