token rightparen expected

Question

Dear community,I am tring to create a conditional colum that checks if a transaction date (column already in my model) falls between 01/07/2021 and 30/06/2022 then the new column will output FY 21-22 otherwise output FY YY-YY depending on where the date falls but i have been given the error highlighted&nbsp;any help is greatly appreciated&nbsp;&nbsp;

bcdobbs · Accepted Answer

Power query doesn't want the brackets after the if&nbsp;You have if ( stuff )&nbsp;Replace with if condition then stuff else stuff no brackets&nbsp;

Forum Discussion

token rightparen expected

1 Reply

Related content

Expected Token RightParen

Expression.SyntaxError: Token ',' expected.

Token RightParen expected

Expression.SyntaxError: Token Eof expected. and Token Comma expected

Expression.SyntaxError: Token Eof expected.