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

Table.LastN

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

About

Returns the last row(s) from a table, depending on the countOrCondition parameter.

Table.LastN(table as table, countOrCondition as any) as table  

Arguments

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

Remarks

  • If countOrCondition is a number, that many rows will be returned starting from the end of the table.

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

Example

Table.LastN(Table.FromRecords({  
  
    [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  
  
    [CustomerID = 2, Name = "Jim", Phone = "987-6543"],  
  
    [CustomerID = 3, Name = "Paul", Phone = "543-7890"]  
  
}), 1)  
CustomerIDNamePhone
3Paul543-7890
© 2018 Microsoft