Power Query - Get Top N by Group

Learn some amazing tricks for extracting "Top" or "Bottom" records from a table using the GroupBy feature in Power Query. Plus, it will show how to use parameters to allow the user to define grouping strategies, control logic, and record depth. File Download Link: https://www.bcti.com//wp-content/YT_Downloads/BCTI_TopNbyGroup.zip 00:03 Defining the Basic Report Goals 01:17 Defining the Dynamic Report 02:08 Download Course Files 02:17 Examining the Data 02:27 Creating the Basic Top N Query 03:30 Changing the Temporary Aggregator 08:41 Limitation of a Static Report 09:53 Building a User-Friendly Interface 10:09 Understanding the Input Parameters 10:55 Start with a Static Solution 14:08 Removing Unneeded Columns 14:34 Making the Report Dynamic 14:47 Accessing the Advanced Editor 15:01 Making Code Pretty with Formatting 16:08 Making the Grouping Dynamic 17:34 Making Item Count Dynamic 18:44 Making the "Top / Bottom" Dynamic 20:25 Customizing Column Order 21:37 Lesson Recap