Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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]
Proud to be a Super User!
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>
Proud to be a Super User!
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.
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]
Proud to be a Super User!
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |