Forum Discussion
sgannon1
10 years agoFrequent Visitor
'Token then expected' error
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 someth...
- Anonymous10 years ago
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]
Anonymous
10 years agoNot applicable
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]