Replacing Null in Query Editor

[MelbourneBadger]

Hi All, 

Can anyone give me a pointer on how to do/write an expression on how to replace null values with the value inside a cell above it or with the value of the first cell above it that does not have null value? 

Please see below table that I'm working with. Thank you very much before hand. 

[amitchandak · Accepted solution]

@MelbourneBadger , one option is data transformation mode right click on the column and use replace. You use null for null and give the value to be replaced

refer

https://www.youtube.com/watch?v=-fwKhMot9hw

https://www.youtube.com/watch?v=EoRjNx1G2g4

https://forum.enterprisedna.co/t/replace-null-values-to-another-value-in-table-power-bi/3019

[MelbourneBadger]

Thank you very much with the suggestion. The Fill-Down function actually work to replace the Null with the values required.