Power Query
Search…
List.FirstN

List.FirstN

Returns the first set of items in the list by specifying how many items to return or a qualifying condition.
function (list as list, optional countOrCondition as nullable any) as nullable any

Description

Category

List.Selection

Examples

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