Table.FillUp

This function retrieves a table from a specified source table. It fills in any null values in the specified columns by copying the value from the following non-null cell in that column.

Generate a table where the missing values in the column labeled [Column2] are replaced with the value below them from the MTable using Power Query. The original table contains records with values assigned to Column1 and Column2. The function MTable.FillUp is used on the table with the values {1, 2}, {3, null}, {5, 3} to fill up the null values in Column2 with the value below. The output table will display the updated records as follows: {1, 2}, {3, 3}, {5, 3}.