Table.ReplaceErrorValues Function in Power Query
The Table.ReplaceErrorValues function in Power Query replaces the error values in the specified columns of the table with the corresponding specified value.
Syntax
Table.ReplaceErrorValues(table as table, errorReplacement as list) as table
The function has the following parameters:
- table: The input table you want to work on.
- errorReplacement: A list of column name and replacement value pairs.