Power Query - Alternate Group By Strategies

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: https://www.bcti.com//wp-content/YT_Downloads/BCTI_GroupBy.Local.zip 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