Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Power Query Group By - Complete Lesson with 10 Examples

ExcelIsFun via YouTube

Overview

This course on Power Query Group By teaches how to utilize the Group By feature for calculations and data analysis through 10 examples covering various applications. Students will learn the basics of Group By, Table.Group M Code function, ranking, sorting, frequency distribution, and more. The teaching method involves practical demonstrations and explanations. This course is intended for individuals interested in enhancing their Excel and Power BI skills, particularly in data manipulation and analysis using Power Query.

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

Reviews

Start your review of Power Query Group By - Complete Lesson with 10 Examples

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.