Table.Range

Table.Range is a Power Query M function that retrieves rows from a table starting at a specified offset. The function returns a new table containing the selected rows, with an optional count parameter to specify how many rows to return.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

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

Description

Returns the rows from the table starting at the specified offset. An optional parameter, count, specifies how many rows to return. By default, all the rows after the offset are returned.

Examples

Return all the rows starting at offset 1 in the table.

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
 )

 /* Output: 
Table.FromRecords( {
    [CustomerID = 2, Name = "Jim", Phone = "987-6543"],
    [CustomerID = 3, Name = "Paul", Phone = "543-7890"],
    [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
} )
 */

Return one row starting at offset 1 in the table.

// Output: Table.FromRecords( {[CustomerID = 2, Name = "Jim", Phone = "987-6543"]} )
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,
    1
 )

Other functions related to Table.Range are:

BI Gorilla Youtube Channel

Last update: August 28, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/table-range
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.