Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Using ReplaceValue to conditionally replace a cell with a numeric value based on another column's value

I've seen lots of suggestions for when one is populating cells with text, but what if the new value is a number?  In the example below, I filtered a table to a single row and requesting if the ticker...
ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
2 years ago

You old value argument is incorrect

 

= Table.ReplaceValue(
        #"Filtered Rows1",
        each[Total Cost],
        each if Text.Contains([Ticker],"T") then 5 else 3,
        Replacer.ReplaceValue,
        {"Total Cost"})