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.
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
The code you posted starts with
= if (Why the paranthesis?