'Token then expected' error

[sgannon1]

Hi all, 

Can anybody please tell me what 'token then expected' error means?

I have created the below formula (I am trying to allocated fiscal year to each month), but obviously I am doing something wrong.

[kcantor]

This is referring to the proper set up of the if statement. It is not like excel. It needs a 'then' and and 'else' instead of commas.

It should be:

=if [Month]>9 then [year] + 1 else [year]

If in PQL follws this format:

= if <Logical_test> then <result> else <alternate_result>

[Anonymous]

@kcantor  or @smpa01 See below If then error for custom column. It is only erroring out the first then- please advise how to fix this formula. thank you

[Anonymous]

I figured it out nevermind. Once I removed all the ) before each of the thens the formula was accepted. Wish the error highlighted the ) parenthesis --calling it a token Then error is misleading bc the then is already there.

[KHorseman · Accepted solution]

You're using DAX syntax to write a function in M. The query editor uses a different language. It should be

=if [Month] > 9 then [Year] + 1 else [Year]