Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lavdeepk
Resolver I
Resolver I

Calendar function behaving weird / How to create a calendar table between these two dates

Hi All,

I want to create a new date table using the calendar function. Calendar formula working when I pass Start/ End from another table But when I pass Start/ End date hard-code in calendar formula showing wired result I am sharing sample result below

 

Here I want to create a Q4 Calendar table but formula return date starting from 01-04-2019 

Please help me how can create a calendar table between these two dates 2020-12-31,2020-10-01

Capture.JPG

3 ACCEPTED SOLUTIONS
Pragati11
Super User
Super User

Hi @lavdeepk ,

 

Your CALENDAR dax function syntax is wrong. You can't directly pass date values. You have to pass dates using DATE function:

 

= CALENDAR (DATE (2020, 12, 31), DATE (2020, 10, 01))

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

HI @lavdeepk ,

 

Save your Power BI report --> Close it --> Reopen it --> Try again creating your calendar table.

 

If still there is this issue, share your pbix file.

 

Also, I am hopinh you are on the latest Power BI Desktop update?

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

@Pragati11

 I Just uninstall power bi desktop and install again now calendar function working fine

 

Thanks Pragati 

View solution in original post

6 REPLIES 6
Pragati11
Super User
Super User

Hi @lavdeepk ,

 

Your CALENDAR dax function syntax is wrong. You can't directly pass date values. You have to pass dates using DATE function:

 

= CALENDAR (DATE (2020, 12, 31), DATE (2020, 10, 01))

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi @Pragati11 

Thanks for the reply

I have modified Dax accordingly but nothing change see below SS

 

Capture.JPG

Hi @lavdeepk ,

 

Not sure what is happening at your end. But I see this working correctly at my end:

 

Pragati11_0-1603295417502.png

 

Try creating a new table and then go to data view and check.

 

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@Pragati11  I also use calendar function previously never face any issue. i am unable to figure out why this happening to me 🤔🤔

HI @lavdeepk ,

 

Save your Power BI report --> Close it --> Reopen it --> Try again creating your calendar table.

 

If still there is this issue, share your pbix file.

 

Also, I am hopinh you are on the latest Power BI Desktop update?

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@Pragati11

 I Just uninstall power bi desktop and install again now calendar function working fine

 

Thanks Pragati 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.