Power Query Group By - Complete Lesson with 10 Examples

Power Query Group By - Complete Lesson with 10 Examples

ExcelIsFun via YouTube Direct link

1. Introduction and video topics

1 of 18

1 of 18

1. Introduction and video topics

Class Central Classrooms beta

YouTube playlists curated by Class Central.

Classroom Contents

Power Query Group By - Complete Lesson with 10 Examples

Automatically move to the next video in the Classroom when playback concludes

  1. 1 1. Introduction and video topics
  2. 2 2. What does Group By do?
  3. 3 3. When to use Group By or other tools such as PivotTables
  4. 4 4. Basics of Group By feature
  5. 5 5. Table.Group M Code function
  6. 6 6. How to Hack Group By dialog box to get the User Interface to write most of the M Code Standard Deviation calculation
  7. 7 7. Type M Code for Group By Calculation Unique List of SalesReps who Sold Product
  8. 8 8. Ranking in Power Query
  9. 9 9. Group By: Two Conditions
  10. 10 10. Sort by Multiple Columns Different than in Excel
  11. 11 11. Sort a List
  12. 12 12. Group By Back-To-Back: Frequency Distribution For Failed Student Classe Combination
  13. 13 13. Group By: Add Blank Row After Each Group Bill Szysz
  14. 14 14. Table Literal
  15. 15 15. Join operator to append tables
  16. 16 16. Group By 4th Argument: Consecutive Occurrences
  17. 17 17. Video Summary and Conclusions
  18. 18 18. Closing and Video Links

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.