List.Modes Function in Power Query

The List.Modes function return the item that appear the most in the list. If multiple items are appear with the same maximum frequency, all of them are returned, unlike the List.Mode where the last item is chose in case of multiple items have the same frequency. If the list is empty an exception is thrown.

Syntax

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

Example:

Power Query M

let
  source = {"India", "America", "Canada", "Canada", "Australia", "England", "America"}, 
  return = List.Modes(source)
in
    return

The output will be shown in the following image:

Previous Next