Power Query - Get Top N by Group
Автор: BCTI
Загружено: 2024-07-25
Просмотров: 6657
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
