Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 formul...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    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

  • Pragati11's avatar
    Pragati11
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    5 years ago

    Pragati11

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

     

    Thanks Pragati 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Pragati11 

Thanks for the reply

I have modified Dax accordingly but nothing change see below SS

 

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi Anonymous ,

 

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

 

 

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

 

Thanks,

Pragati

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

    • Pragati11's avatar
      Pragati11
      Super User
      5 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Pragati11

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

         

        Thanks Pragati