Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX syntax

Hi I need a help regarding how to fix the error message received when i was trying to use calender syntax

The syntax for '.1' is incorrect. (DAX(CALENDAR(DATE(2005.1.1),DATE(2015.12.31)))). This is the syntax which i used

d = CALENDAR (DATE(2005,1,1),DATE(2015,12,31))

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You should use commas to seperate the year month and date:

    (DAX(CALENDAR(DATE(2005,1,1),DATE(2015,12,31))))

    The error "The syntax for '.1' is incorrect." is refering to the first dot in your code.

    Hope this helps