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