Dive into a comprehensive 34-minute tutorial on Power Query's Group By feature, exploring 10 practical examples ranging from basic to advanced applications. Learn how to leverage Group By for calculations and data analysis, understand when to use it versus other tools like PivotTables, and master the Table.Group M Code function. Discover techniques for hacking the Group By dialog box, typing M Code for unique list creation, implementing ranking, handling multiple conditions, and sorting by multiple columns. Explore advanced concepts like frequency distribution, adding blank rows after groups, using table literals, and working with the join operator. Gain insights into consecutive occurrences and walk away with a solid understanding of Power Query's Group By capabilities for enhanced data manipulation in Microsoft 365 Excel and Power BI.
Overview
Syllabus
1. Introduction and video topics
2. What does Group By do?
3. When to use Group By or other tools such as PivotTables
4. Basics of Group By feature
5. Table.Group M Code function
6. How to Hack Group By dialog box to get the User Interface to write most of the M Code Standard Deviation calculation
7. Type M Code for Group By Calculation Unique List of SalesReps who Sold Product
8. Ranking in Power Query
9. Group By: Two Conditions
10. Sort by Multiple Columns Different than in Excel
11. Sort a List
12. Group By Back-To-Back: Frequency Distribution For Failed Student Classe Combination
13. Group By: Add Blank Row After Each Group Bill Szysz
14. Table Literal
15. Join operator to append tables
16. Group By 4th Argument: Consecutive Occurrences
17. Video Summary and Conclusions
18. Closing and Video Links
Taught by
ExcelIsFun
Related Courses
-
Power Query Group By Feature and Table.Group Function - Examples
-
Power BI M Code for Moving Annual Total - Custom Function Power Query Custom Column
-
Power Query Count & Extract Customer Names for 8 Sales Coupon Groups
-
Master Power Query M Code and Data Shaping for Data Analysis
-
Power Query Complete M Code Introduction - Values, Let, Lookup, Functions, Parameters, More
-
Lookup Manager Names in Column Headers to Create Report - Excel Magic Trick 1866
