Forum Discussion
Anonymous
8 years agoNot applicable
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)