replace_value
Replace whole-cell values in Power Query columns, supporting null, text, number, and logical changes.
Instructions
Power Query Replace Value (whole-cell): swap the entire cell value in a column - unlike replace_values which replaces a text substring. Appends Table.ReplaceValue (Replacer.ReplaceValue) to the table's M query, supporting null<->value and numeric replacements (e.g. null->0, 0->null, -1->0). valueType (text | number | logical | null) applies to BOTH oldValue and newValue.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| column | Yes | the column to replace in | |
| newValue | No | the replacement whole-cell value (omit/empty for null) | |
| oldValue | No | the whole-cell value to find (omit/empty for null) | |
| sessionId | Yes | ||
| valueType | No | text | number | logical | null (default text) | text |
| partitionName | No | partition name (optional; defaults to the first partition) |