Forum Discussion
Replace multiple nulls at once in Power Query
I've got a table with a few columns of numerical data, and a few with text data. For all of the numerical columns, where the value is null, I want to replace those with a 0. For columns where it is t...
Motivation from solution above ... as I needed to replace null values in the whole table without specifying columns - modified a bit suggested formula:
= Table.ReplaceValue(Source,null,0,Replacer.ReplaceValue,Table.ColumnNames(Source))
where Source - a reference to the data table.
many thanks for this. It helped me solve the exact same issue I was having.