Power Query Group By Feature and Table.Group Function - Examples

Power Query Group By Feature and Table.Group Function - Examples

ExcelIsFun via YouTube Direct link

) Joined Text Items from Unique List formula in Custom Column Based on Grouped Records Table

8 of 14

8 of 14

) Joined Text Items from Unique List formula in Custom Column Based on Grouped Records Table

Class Central Classrooms beta

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

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.