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), DATE (2015, 12, 31))))."

 

I tried ; as well no luck

 

It only works when we add two commas

 

dateTable = CALENDAR (DATE(2017,,1,,1), DATE(2017,,12,,31))

 

My regional setting is English (South Africa)

Desktop version Version: 2.54.4970.961 64-bit (January 2018)

 

 

Data Modeling

6 Replies

  • 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
    6 years ago

    I had the same issue. The Decimal and List Seperator had the same value, so I changed Decimal to a '.' and started working again.