Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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....
Try replacing the semicolons with a comma.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |