Forum Discussion
Update a value based on another value
I have a table and there is a null based on a missing persons name. I want to update null with a value. This table contains an id and name. The only person I didn't have in a table with ID 685. I ...
Anonymous this will do it
= Table.ReplaceValue(#"Reordered Columns",each [Forecast Manager],
each if [Forecast Manager Id] = 685 and [Forecast Manager] = null then 685 else [Forecast Manager],
Replacer.ReplaceValue,{"Forecast Manager"})
