Table.Range
This function retrieves rows from a table starting at a specified position. There is an optional parameter called count that determines the number of rows to be retrieved. If count is not provided, by...
This function retrieves rows from a table starting at a specified position. There is an optional parameter called count that determines the number of rows to be retrieved. If count is not provided, by default all rows from the specified offset onward are returned.
Example 1
Retrieve all data starting from the second row in the table.
Usage:
Power Query MTable.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"]
})
Example 2
Retrieve one row starting from the second row in the table.
Usage:
Power Query MTable.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)
Output:
Table.FromRecords({[CustomerID =