Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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???
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Ah okay that worked! Thank you so much!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.