Table.SplitAt

The function returns a list consisting of two tables: one table that includes the first N rows of the original table (determined by count) and another table containing the remaining rows. By enumerati...

Syntax

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

About

The function returns a list consisting of two tables: one table that includes the first N rows of the original table (determined by count) and another table containing the remaining rows. By enumerating the tables in the resulting list exactly once and in sequential order, the function ensures that the original table is also enumerated only once.

Explanation

Retrieve the initial two rows and the subsequent rows in the specified table. Employ the Power Query function MTable.SplitAt to achieve this. The output will display the first two rows separately and the remaining rows grouped together.