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_D... 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
Power Query - Alternate Group By Strategies
Power Query - Query Folding (The key to faster query execution)
Make your Group By Operations Dynamic in Power Query M
Power Query - GROUPBY Comparer Function Argument (Creating Bin Ranges)
Create an Interactive Top N Report in Excel (includes duplicate values) with Filter Function
Create Index Column By Group in Power Query
List.Buffer: This One Power Query Function Can Speed Up Your Refresh
How to use Power Query to Combine Multiple Files that have different headings
Power Query - Extract PDF Tables by the Table's Content
Power Query - Parameters with Error Checking (with bonus tip)
Summarizing Data with Group By in Power Query
Power Query was HARD until I learned these 7 Tips
I Bet You Didn’t Know Power Query Could Do This (7 Tricks)
Don’t Just Click Expand – Do This Instead
APQ15 | How "each" & "_" work? | Advanced Power Query
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
Avoid Power Query Failures: The Smart Way to Manage Column Names
Power Query Running Totals - The Right Way!
Nested Lists in Power Query: You’ll Wish You Knew This Sooner
