Forum Discussion
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
Hi Anonymous ,
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
HI Anonymous ,
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
I Just uninstall power bi desktop and install again now calendar function working fine
Thanks Pragati
6 Replies
Hi Anonymous ,
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