Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

    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

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Ah okay that worked! Thank you so much!!