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)