Power Query
Search…
List.Select

List.Select

Returns a list of values that match the condition.
function (list as list, selection as function) as list

Description

Returns a list of values from the list list, that match the selection condition selection.

Category

List.Selection

Examples

Find the values in the list {1, -3, 4, 9, -2} that are greater than 0.
1
List.Select({1, -3, 4, 9, -2}, each _ > 0)
Copied!
{1, 4, 9}
Last modified 3yr ago