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

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

Pragati11

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

Thanks Pragati