Table.FillUp is a Power Query M function that propagates the value of the next cell to null-valued cells above in specified columns. The function returns a new table with filled up values.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Table.FillUp(
table as table,
columns as list,
) as tableDescription
Returns a table from the table specified where the value of the next cell is propagated to the null-valued cells above in the columns specified.
Examples
Return a table with the null values in column [Column2] filled with the value below them from the table.
Table.FillUp(
Table.FromRecords( {
[Column1 = 1, Column2 = 2],
[Column1 = 3, Column2 = null],
[Column1 = 5, Column2 = 3]
} ),
{"Column2"}
)
/* Output:
Table.FromRecords( {
[Column1 = 1, Column2 = 2],
[Column1 = 3, Column2 = 3],
[Column1 = 5, Column2 = 3]
} )
*/
Related functions
Other functions related to Table.FillUp are:
