Returns a collection of values from the given list that meet the specified criteria.
Syntax
List.Select(list as list, selection as function) as list
About
Returns a collection of values from the given list that meet the specified criteria.
Explanation
Identify the elements in the collection {1, -3, 4, 9, -2} that are larger than 0. Implement Power Query MList.Select({1, -3, 4, 9, -2}, each _ > 0) to achieve this. The resulting output will be {1, 4, 9}.