Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.FirstN

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns the first row(s) of a table, depending on the countOrCondition parameter.

Table.FirstN( table as table, optional countOrCondition as any) as table  

Arguments

ArgumentDescription
TableThe Table to check.
optional countOrConditionDepending on the type, more than one row will be returned.

Remarks

  • If countOrCondition is a number, many rows (starting at the top) will be returned.

  • If countOrCondition is a condition, the rows that meet the condition will be returned until a row does not meet the condition.

Example

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)  
CustomerIDNamePhone
1Bob123-4567
2Jim987-6543
© 2018 Microsoft