Table.Skip
This function returns a table without the first specified number of rows, countOrCondition, from a given table called table. The number of rows skipped is determined by the optional parameter countOrC...
This function returns a table without the first specified number of rows, countOrCondition, from a given table called table. The number of rows skipped is determined by the optional parameter countOrCondition.
If countOrCondition is not provided, only the first row will be skipped.
If countOrCondition is a numerical value, that many rows (beginning from the top) will be skipped.
If countOrCondition is a condition, rows meeting the condition will be skipped until a row does not meet the condition.
Example 1
Omit the initial row from the table.
Usage
To achieve this in Power Query M language, use the function Table.Skip with the following syntax:
Table.Skip(
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
The resulting table will contain:
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
Exclude the first two rows from the table.
Usage
In Power Query M, employ the function Table.Skip with the code provided below:
Table.Skip(
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone =