Table.FillUp

Table

Fills null values in specified columns with the next non-null value below.

Syntax

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

Parameters

Name	Type	Required	Description
`table`	`table`	Yes	The input table containing null values to fill.
`columns`	`list`	Yes	A list of column names to apply the fill-up operation to.

Return Value

table — A table with null values in the specified columns replaced by the next non-null value from below.

Remarks

Table.FillUp scans each specified column from bottom to top. When it encounters a null, it replaces it with the next non-null value from below. If the last value in a column is null, it remains null because there is no subsequent value to propagate.

This is the complement of Table.FillDown. Use Table.FillUp when null values should inherit from the row beneath them, or combine both functions to fill nulls in both directions.

Examples

Example 1: Fill up a column

let
    Source = Table.SelectColumns(Table.FirstN(Sales, 4), {"CustomerName", "Region"}),
    WithNulls = Table.ReplaceValue(Source, "East", null, Replacer.ReplaceValue, {"Region"})
in
    Table.FillUp(WithNulls, {"Region"})

Applied Steps

The final output — applies Table.FillUp on Region, propagating the next non-null value upward so each null inherits the region of the row beneath it.

	CustomerName	Region
1	Alice	West
2	Bob	West
3	Charlie	North
4	Alice	North

Compatibility

✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks

Contributors