cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
unclejemima
Post Patron
Post Patron

Simple Dax expression not working...

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?

1 ACCEPTED SOLUTION
dkay84_PowerBI
Microsoft
Microsoft

Try replacing the semicolons with a comma.

View solution in original post

2 REPLIES 2
CahabaData
Memorable Member
Memorable Member

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....

www.CahabaData.com
dkay84_PowerBI
Microsoft
Microsoft

Try replacing the semicolons with a comma.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.