← Back to List functions

List.Modes

This function retrieves the most frequently occurring items in a list. If the list is empty, an exception will be raised. If there are multiple items with the same highest frequency, all of them will ...

Syntax

List.Modes(list as list, optional equationCriteria as any) as list

About

This function retrieves the most frequently occurring items in a list. If the list is empty, an exception will be raised. If there are multiple items with the same highest frequency, all of them will be returned. To customize the equality testing, you can provide an optional comparison criteria value called "equationCriteria".

Explanation

Identify the elements that occur most frequently in the list {"A", 1, 2, 3, 3, 4, 5, 5} using Power Query MList.Modes function. The result will be {3, 5}.