Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calendar Function only creates 18 Months

Good day all,

 

I have something weird going on I have this formula CALENDAR(DATE(2022, 01, 01), DATE(2026, 12, 31)).

 

The dates created only goes up to 26 September 2024. I tried it on a different machine, and exactly the same. Tried updating Power BI, restarting and nothing works. What am I doing wrong? I have used this previously and worked perfectly.

 

When I change the Start date to 2023 the end date will only go up to 26 September 2025, roughly 18 months from the start date.

Need Help
  • Arul's avatar
    Arul
    3 years ago

    Anonymous ,

    It is working fine,

    Can you check now?

    Thanks,

    Arul

     

2 Replies

  • Arul's avatar
    Arul
    Super User
    3 years ago

    Anonymous ,

    It is working fine,

    Can you check now?

    Thanks,

    Arul

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks Arul,

       

      I resterted again and it seems lik it is working. Or at least the data is there, but on the drop down it is still showing incorrectly. But at least the data is there.