Completed
) Introduction
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Power Query Group By Feature and Table.Group Function - Examples
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) What Does Power Query Group By feature do?
- 3 ) Examples of PivotTable, SUMIFS, Data Model PivotTable and SQL Code to see that Power Query Group By is VERY Similar
- 4 ) Example of Simple Power Query Group By Command for Total Sales
- 5 ) First Look at Table.Group Power Query Function
- 6 ) Example of using Group by to get Tables of Grouped Records, or Matching Records
- 7 ) Standard Deviation Custom Column Based on Grouped Records Table
- 8 ) Joined Text Items from Unique List formula in Custom Column Based on Grouped Records Table
- 9 ) Detail look at Table.Group Function. Edit and create arguments in Third Argument to List Multiple New Columns with Formulas
- 10 ) Power Query Group By to Help Rank Sales for Each Product
- 11 ) Group By More Than One Column
- 12 ) Fast Trick for Group By: Placeholder Function
- 13 ) Add new data and see that everything updates.
- 14 ) Summary
