Forum Discussion
Automatically replace all blank values with N/D
You would need to do two replacements. Right-click on the column and select Replace Values, then leave Value to Find empty
Then do it again and put null (all lower case) in the Value to Find box.
The first will find when it is empty, which is represented by "", the second will replace null values, which is not the same as empty. The term null in all lower case is a Power Query keyword. It will not look for the text "null."
You would need to do two replacements. Right-click on the column and select Replace Values, then leave Value to Find empty
Then do it again and put null (all lower case) in the Value to Find box.
The first will find when it is empty, which is represented by "", the second will replace null values, which is not the same as empty. The term null in all lower case is a Power Query keyword. It will not look for the text "null."