Power QueryExercises

Table.FillDown

Table function · By Tahir Nas · Examples run in our simulator · Published · Updated

Replaces nulls with the value above.

When to use it

Use it for report layouts where a group label appears only on the first row of its block. Make sure the blank cells are null first; empty text isn't filled.

Syntax

Table.FillDown(table as table, columns as list) as table

Parameters

columns
Columns to fill.

Returns

The filled table.

Example

Table.FillDown(#table({"Region", "Store"}, {{"North", "A"}, {null, "B"}, {"South", "C"}, {null, "D"}}), {"Region"})

Result

RegionStore
NorthA
NorthB
SouthC
SouthD

Example: turn blanks into null, then fill

Empty strings aren't null, so replace them before filling down.

Table.FillDown(Table.ReplaceValue(#table({"Region", "Store"}, {{"North", "A"}, {"", "B"}}), "", null, Replacer.ReplaceValue, {"Region"}), {"Region"})

Result

RegionStore
NorthA
NorthB

Both results are produced by the Power Query Exercises simulator, an independent implementation of a documented subset of M, and checked on every build.

Good to know

Common mistakes

The matching command in Excel

Excel for Windows
Right-click the column header > Fill > Down
What you see
Nulls below a value take that value until the next value.

Paths are for the Power Query editor in Excel for Microsoft 365, checked against Microsoft's documentation on 8 November 2026: Fill values in a column (Microsoft Learn).

Exercises that use Table.FillDown

Learn more

Related functions

Official documentation: Table.FillDown on Microsoft Learn.