Table.SplitAt

Table.SplitAt(table as table, count as number) as list

About

Returns a list containing two tables: a table with the first N rows of table (as specified by count) and a table containing the remaining rows of table. If the tables of the resulting list are enumerated exactly once and in order, the function will enumerate table only once.

Example 1

Return the first two rows of the table and the remaining rows of the table.

Usage

Power Query M

Table.SplitAt(#table({"a", "b", "c"}, {{1, 2, 3}, {4, 5, 6}, {7, 8, 9}}), 2)

Output

Power Query M

{
    #table({"a", "b", "c"}, {{1, 2, 3}, {4, 5, 6}}),
    #table({"a", "b", "c"}, {{7, 8, 9}})
}