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: Find the values in the list that are greater than 0.

Power Query M

let
    Source = List.Select({57, -38, 41, 49, -12}, (n) => n > 0)
in
    Source

The output of the above code is shown below:

Note: Lambda Function (n) => n > 0:
• This is an anonymous function (lambda) that takes a single argument n (representing each item in the list) and checks if n is greater than 0.
• If the condition is true (n > 0), the item is included in the result. If false, the item is excluded.

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