Power Query Table.Skip While Row Is Blank

This post explains how to use the Table.Skip function in Power Query to dynamically skip rows with null values in a specified column, making the process flexible across files.

July 23, 2023 · 1 min · 66 words

There are times that you you want to use the Table.Skip Power Query function, but the number of rows you want to skip varies from file to file in your folder. You want the number of rows to be dynamic.

The function below will count the number of rows under the column Column4 while the rows are nulls.

Table.Skip(Source, each [Column4] = null)

Watch the video.