Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |