Forum Discussion
Automatically replace all blank values with N/D
Hello,
I know this is probably super simple but I don´t know why I cannot find anything.
I have a DashBoard that is meant to be updated whenever it is needed. Some of the cells in Power Query are blank or null, I wanted to replace them automatically with N/D. Can someone please help me? (Remember that when I upload another new CSV it atomatically do this process)
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."
1 Reply
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."