List.Mode

The function identifies the item with the highest frequency in a given list. If the list is empty, an error will be raised. In case of multiple items having the same highest frequency, the last one wi...

Syntax

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

About

The function identifies the item with the highest frequency in a given list. If the list is empty, an error will be raised. In case of multiple items having the same highest frequency, the last one will be selected. Additionally, users have the option to provide a specific comparison criteria, equationCriteria, for customizing equality evaluation.

Explanation

Identify the most commonly occurring item in the given list: {"A", 1, 2, 3, 3, 4, 5} using the Power Query MList.Mode function. Output: 3 Identify the most frequently appearing item in the provided list: {"A", 1, 2, 3, 3, 4, 5, 5} by utilizing the Power Query MList.Mode function. Output: 5