Forum Discussion
Replace blank value
Hi, I was trying to replace blank value with some value by using replace value command in power query but the answer is same as blank value. Before that I have tried with trim column and after that ...
Tried with Concatenate and after that used the replace value in query editor. It was empty that's why I wasn't able to replace it with any value. So I have tried to Concatenate with "-" and then replaced that value.
Hi Anonymous ,
For empty, have you tried the below step which AlexisOlson mentioned, it seems works fine.
#"Replaced Value" = Table.ReplaceValue(Source,"","EmptyString",Replacer.ReplaceValue,{"Text"})
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.