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

Table.Range

Owen Duncan|Last Updated: 4/19/2018

About

Returns the specified number of rows from a table starting at an offset.

Table.Range( table as table, offset as number, optional count as nullable number) as table  

Arguments

ArgumentDescription
tableSource table.
OffsetStarting row offset.
optional countOptional number of rows to return. If count is not provided, all rows are returned starting from offset.

Remark

  • Table.Range is similar to List.Range but requires a table as input.

Example

Table.Range(Table.FromRecords({  

    [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  

      [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,  

      [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,  

      [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]  

}), 1, 2)  
CustomerIDNamePhone
2Jim987-6543
3Paul543-7890
© 2018 Microsoft