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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.