Forum Discussion

Helper I

5 years ago

Solved

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 ...

amitchandak
5 years ago
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

amitchandak

Super User

5 years ago

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
Helper I
5 years ago
Thank you very much with the suggestion. The Fill-Down function actually work to replace the Null with the values required.

Forum Discussion

Replacing Null in Query Editor

Related content

power query editor slow loading

Query Editor - replace multiple values

Query editor replacing values based on another column

= Replace UNICHAR(10) in Query Editor

how to replace error in query editor