Forum Discussion
Replacing Null in Query Editor
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.
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
2 Replies
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
Thank you very much with the suggestion. The Fill-Down function actually work to replace the Null with the values required.
