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  

ArgumentDescription
tableThe Table to modify.
errorReplacementThe 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"})  

Column1Column2
1hello
2world
Show: