Replace null with last known value in Power Query

0
votes

In Power Query, I am trying to create a custom column that replaces any null values with the last known value in that column. i.e.

enter image description here

What would the code be for this new column in M?

BTW - While I believe that this would be easier in Power Pivot, I have already build my data model (and dashboard) based off the column names. Changing the data model would cause all my charts, tables and metrics to be rebuilt.

1
excelpowerquery

1 Answers

4
votes

In the Query Editor, click on the column, go to the Transform tab, and choose Fill | Down. It will generate something like = Table.FillDown(Table,{"Amount"}).