Table.ReplaceErrorValues
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Replaces the error values in the specified columns with the corresponding specified value.
Table.ReplaceErrorValues(table as table, errorReplacement as list) as table
| Argument | Description |
|---|---|
| table | The Table to modify. |
| errorReplacement | The list of columns and the value to replace the errors with. The form of the list is {{column1, value1},…} |
- There may be only one replacement value per column, specifying the column more than one will result in an error
Table.ReplaceErrorValues(
Table.FromRows({{1,"hello"},{3,...}}, {"Column1","Column2"}),
{"Column2", "world"})
| Column1 | Column2 |
|---|---|
| 1 | hello |
| 2 | world |
Show: