Replacing null values with blank

[kymramosrpo]

When pivoting columns, I noticed that when a cell has null value, the entire row will not be included in the final result. I used to replace these null values with text (like "0," for example), but it looks like a blank() value will suffice. To replace null with blank values:

Select a column (or multiple columns) > Go to 'Transform' > Click 'Replace values' > In 'Value to find' field, type "null"; for the 'Replace with' field, leave it blank/empty > Click 'OK'

In the step's formula bar, you will find this syntax:

Table.ReplaceValue(#"PreviousStepName", null, "", Replacer.ReplaceValue, {"Column.1", "Column.2", "Column.3"})

I hope this helps!

[v-stephen-msft · Accepted solution]

Hi @kymramosrpo ,

🌹🌹Nice sharing! I believe that some people will benefit from this.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.