Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    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"})
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I tried to follow that logic but it doesn't like my attempt:

 

#"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns1",{"ID", "Name", "Period", "Year", "Created", "Updated", "Forecast Manager ID", "Forecast Manager", "Submitted", "ResourceAllocation", "Report Period"}),
#"Replaced Value" = Table.ReplaceValue(#"Reordered Columns", each if Text.Contains([Forecast Manager ID],"685") then "Rita Carnes" else [Forecast Manager])
in
#"Replaced Value"

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous are you getting an error? Without knowing what error you are getting, it is hard to imagine what is going on.

 

What is data type for your [Forecast Manager Id] column?