Power Query Group By: Basic to Advanced. 10 Examples. 365 MECS Class 16

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/16-M365ExcelClassVideoFiles.zip
This video teaches how to use the Group By feature in Power Query. The 10 examples cover many helpful applications of how to use Group By for calculations and Data Analysis.
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:32) What does Group By do?
3. (01:07) When to use Group By or other tools such as PivotTables
4. (01:44) Basics of Group By feature
5. (03:41) Table.Group M Code function
6. (04:29) How to Hack Group By dialog box to get the User Interface to write most of the M Code (Standard Deviation calculation)
7. (06:56) Type M Code for Group By Calculation (Unique List of SalesReps who Sold Product)
8. (09:52) Group By to Rank 1, 2, 2, 4 (Ties use RANK.EQ function or Skip Ranking)
9. (09:52) Group By to Rank 1, 2.5, 2.5, 4 (Ties use RANK.AVE function or Average Ranking)
10. (09:52) Group By to Rank 1, 2, 2, 3 (Ties use Dense Ranking)
11. (13:39) Group By: Two Conditions
12. (14:36) Sort by Multiple Columns (Different than in Excel)
13. (15:08) Sort a List
14. (16:14) Group By Back-To-Back: Frequency Distribution For Failed Student Classe Combination
15. (20:32) Group By: Add Blank Row After Each Group (Bill Szysz)
16. (21:31) Table Literal
17. (22:11) Join operator to append tables
18. (26:51) Group By 4th Argument: Consecutive Occurrences
19. (32:22) Video Summary and Conclusions
20. (33:04) Closing and Video Links

Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #datamodel #datamodeling,
#groupby #consecutive #occurrence #rank #ranking

ExcelIsFunSun, March 19, 2023 2:45pm