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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

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