Forum Discussion

leahschneider's avatar
leahschneider
Helper III
4 years ago
Solved

Replace Value in Multiple Columns Conditionally

I have a table in Power Query and I need to replace values across multiple columns if one column has a particular value. I've used https://gorilla.bi/power-query/replace-values/#conditional-replace-s...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi leahschneider 

     

    have a try

    = Table.ReplaceValue(
#"Removed Other Columns",
each [Income] > 50000,
null,
(x,y,z)=> if y then x*2 else x,
{"Kidhome", "Teenhome"}
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi leahschneider 

 

have a try

= Table.ReplaceValue(
#"Removed Other Columns",
each [Income] > 50000,
null,
(x,y,z)=> if y then x*2 else x,
{"Kidhome", "Teenhome"}
)