Table.FirstN
Returns the first count rows specified.
function (table
as table, optionalcountOrCondition
as nullable any) as table
Returns the first row(s) of the table
table
, depending on the value of countOrCondition
: Table.Row operations
Find the first two rows of the table.
Table.FirstN(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"] , [CustomerID = 3, Name = "Paul", Phone = "543-7890"]}), 2)
Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567"],[CustomerID=2,Name="Jim",Phone="987-6543"]})
Find the first rows where [a] > 0 in the table.
Table.FirstN(Table.FromRecords({[a = 1, b = 2], [a = 3, b = 4], [a = -5, b = -6]}), each [a] > 0)
Table.FromRecords({ [a = 1, b = 2], [a = 3, b = 4] })
Last modified 4yr ago