Forum Discussion
Replacing Values in Column Based on Parameter Value
I've seen examples of this online and thought I'd give it a go, except I'm using a column and a parameter (Not sure if that matters) and the examples were using two columns. Reported Phish? is my column and Reporter Enabled is the Parameter. When Reporter Enabled equals "No" I'd like every value in the Reported Phish? column to be "No"
#"Replaced Value" = Table.ReplaceValue(#"Added Conditional Column",each [Reported Phish?],each if [Reporter Enabled] = "No" then "No" else [Reported Phish?],Replacer.ReplaceValue,{"Reported Phish?"})
When I run this code I get a syntax error not recognizing my column name. It is spelled correctly! Not sure what the issue could be. Any ideas???
You should do this with a different M function. Below is one way to do this. Paste this code in the formula to replace the one you showed.
= Table.TransformColumns(#"Added Conditional Column",{{"Reported Phish?", each if ReporterEnabled = "No" then "No" else _, type text}})
The "_" is how you reference the existing value in such an expression. Also note the parameter name ReporterEnabled has no space so the #" " is not required when referencing it.
Regards,
Pat
2 Replies
You should do this with a different M function. Below is one way to do this. Paste this code in the formula to replace the one you showed.
= Table.TransformColumns(#"Added Conditional Column",{{"Reported Phish?", each if ReporterEnabled = "No" then "No" else _, type text}})
The "_" is how you reference the existing value in such an expression. Also note the parameter name ReporterEnabled has no space so the #" " is not required when referencing it.
Regards,
Pat