Deuts Log

The Omniverse: Unveiling the endless tapestry of topics.

Power Query Table.Skip While Row Is Blank

Posted on Jul 23, 2023

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.