List.Select Function in Power Query

The List.Select function returns the list of values from the given list that match the given condition.

Syntax

List.Select(list as list, selection as function) as list

Example: Select the List elements that has the value “Canada” from the list.

Power Query M

let
  Source = {"India", "America", "Canada", "Japan", "Australia", "England", “Canada”}, 
  Return = List.Select(Source, each _="Canada")
in
  Return

The output of the above code is shown below:

Previous Next