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
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi Anonymous,

 

As your region set as English (South Africa), by default the list separator is " ; ". 

 

In your scenario, if you don't change the list separator, you can specify the DAX to create a calendar table below:

 

Table = CALENDAR ( DATE ( 2017;1; 1 ); DATE ( 2017; 12; 31 ) )

 

 

Best Regards,
Qiuyun Yu 

  • 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 [ , ]