Simple Dax expression not working...

[unclejemima]

I'm trying to use the Dax expression to create a date table.  I found a simple blog on this and gave it a try.  I'm not able to make it work and I think I'm missing something obvious.

In Power BI desktop I go to the "Modeling" tab, then "New Table", then paste this in formula field...

Date =CALENDAR (DATE(2000;1;1); DATE(2025;12;31))

Theoretically its supposed to work but I get the error "The syntax for ';' is incorrect. (DAX(CALENDAR (DATE(2000;1;1); DATE(2025;12;31))))."

What am I doing wrong?

[CahabaData]

for sure don't paste in the formula

build it from the keyboard - along the way the intellisense will help guide and give insight as to a syntax issue....

[dkay84_PowerBI · Accepted solution]

Try replacing the semicolons with a comma.