Forum Discussion
RightParen error in Custom Column
Hi Anonymous
You can add a conditional column, it is easier way to achieve your goal.
https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No this does not work with or wthout parenthesis
Reminder I'm after text not a value
if test then text_if _true else text _if_false
I can't make out what your column name is, but if you add a custom column in power query this is the syntax
if [column name] = "Box Hill" then "Australia" else "Other"
Notice that the comparison is case sensitive
Cheers,
Sturla
I domnt type in the column name I insert it from the list provided
if( [#"Which Centre do you work in?"] = "Box Hill" then "Australia" else (from here a new if test begins)
as soon as I start typing "Australia" the error appears
In the screen shot you just provided, there is a paranthesis after if. The red underline highlighting error, behaves a bit erratic, so when I write this custom column it pops up on every word, even if there is no error. But once I get to the end, it disappears, and the formula evaluates correctly
It does not disappear. I have tried completing the formula many times
The RightParen error remains and the "ok" button id greyed out so I cannot click on it