Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!!
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
10 | |
7 | |
7 | |
6 | |
6 |