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