Power Query - MODE Function (with 2 ways to display results)

Описание: Learn how to use the different MODE functions in Power Query to discover the most frequently occurring item in a list. Plus, see 2 different techniques for expanding lists, either as row-based or delimited output.

File Download Link:
https://www.bcti.com//wp-content/YT_D...

00:08 Understanding the MODE Function
00:15 Defining the Mission
00:35 Bringing the Data Into Power Query
00:50 Grouping Data By Month Names
01:21 Using the MODE Function When Grouping
01:55 Understanding the 2 Versions of MODE Functions
03:00 Expanding the Nested Lists
03:19 Restoring the Missing "Expand Lists" Button
04:13 2 Ways to Expand Nested Lists