Forum Discussion
RightParen error in Custom Column
Can someone help with this formula. I'm getting a RightParen error if( [#"Which Centre do you work in?"] = "Box Hill" then "Australia" I need to do multiple if then else statements whereby...
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.
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?