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?
Go to Solution.
Try replacing the semicolons with a comma.
View solution in original post
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....
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.