Downloads
Power Query MTable: values and fillBeginner

Table.FillUp

Fills blank cells in the listed columns with the value from the row below.

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

Returns: The table with blanks filled up.

What it does

Table.FillUp is the opposite of Table.FillDown. It copies the next filled value upward into the blank cells above it. Some reports put the label on the last line of a block, not the first, and this step carries that label up to the rows that need it.

Syntax and arguments

Example

A report puts the period name on the last row of each block of transactions. The period is filled up so every transaction in the block carries it.

let
    Source = Excel.CurrentWorkbook(){[Name = "PeriodReport"]}[Content],
    Filled = Table.FillUp(Source, {"Period"})
in
    Filled

Each blank Period takes the value from the next filled row below it. The rows that hold the transactions keep their own details.

Things to watch

In business terms

Reports laid out for printing often put a heading or period at the end of a block. Filling up turns that layout into the table format that a summary needs, without retyping the labels.

Related functions

All Power Query M functions · View as Markdown · M basics