token rightparen expected

[Russ99]

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

any help is greatly appreciated 

[bcdobbs · Accepted solution]

Power query doesn't want the brackets after the if

You have if ( stuff )

Replace with if condition then stuff else stuff no brackets