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.
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?