Forum Discussion
if statement syntax error
Hello, I am a bit new to this platfrom, and I am trying to write the below formula, but I am getting a Token RightParen expected error, and I am not sure why is the issue. It is highligting the "...
Hi Anonymous
In query editor,you may create a custom column with M language:Text.Start and Text.End like below.
=(if Text.Start([Season],1)="F" then "FH" else "SS")&Text.End([Season],2)
Second way in DAX with IF function.New a column in data view.
Column = IF(LEFT(Table5[Season],1)="F","FH","SS")&RIGHT(Table5[Season],2)
Regards,
Where exactly are you doing this. If you are doing a DAX formula, this will not work.
Please look at this similar question and solution...
https://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999
good luck!
Luis
If this was helpful, consider marking it as solved so others can find it easily.