Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

DAX CALENDAR syntax issue

I tried to create a dateTable using  CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2017, 12, 31 ) ) I kept getting the error message   "The syntax for '.1' is incorrect.(DAX(CALENDAR(DATE(2005, 1, 1), DA...
Data Modeling
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Qiuyun Yu,

 

Not sure if you got my previous reply but changing to ; did not work.

 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi Anonymous,

 

Would you please check the List operator format in your region for OS? 

 

 

Best Regards,
Qiuyun Yu 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Qiuyun Yu,

     

    I have the same issue, the dax formula only works when I use the double comma's even when my List Separator is set to [ , ]. So it seems that this setting is not responsible for the syntax error.



     

    List separator set to [ , ]