Table.Skip

Table

Skips the first N rows of a table, or rows matching a condition.

Syntax

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

Parameters

Name	Type	Required	Description
`table`	`table`	Yes	The table to skip rows from.
`countOrCondition`	`any`	Yes	A number specifying how many rows to skip, or a function that skips rows while the condition is true.

Return Value

table — A table with the first N rows removed, or the leading rows that satisfied the condition removed.

Remarks

Table.Skip removes rows from the beginning of a table. When passed a number, it skips exactly that many rows. When passed a condition function, it skips consecutive rows from the top while the condition is true — it stops skipping at the first row that fails the condition.

This is the complement of Table.FirstN: where Table.FirstN keeps the first N rows, Table.Skip removes them. A common use case is skipping header or metadata rows in files that have non-tabular content at the top.

Examples

Example 1: Skip the first 5 rows

Table.SelectColumns(Table.Skip(Sales, 5), {"OrderID", "CustomerName", "Product"})

Result

	OrderID	CustomerName	Product
1	6	Bob	Thingamajig E
2	7	Charlie	Widget C
3	8	Diana	Gadget B

Compatibility

✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks