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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors