Forum Discussion

mateszenci's avatar
mateszenci
Regular Visitor
4 years ago
Solved

Power BI desktop issue (calendar)

Hi,    I'm facing with an issue that affect my development. After new year (2022) i tried to open my .pbix file and i got this messege:    Feedback Type: Frown (Error) Error Message: <pi>The s...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi mateszenci 

    There is a possibility that your Max date is last year, so when the new year starts, this error will be returned. Maybe you can change your computer time to 2021,then open the pbix file to change the formula.

    In addition, CALENDARAUTO() searches among all the dates in the data model and automatically finds the first and last year referenced within the model. CALENDAR() returns a table with a single column named "Date" that contains a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates. Using CALENDAR() instead of CALENDARAUTO() will help you create tables better

     

    Best Regard

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

mateszenci CALENDARAUTO is not a recommended method to add the dimension. It scans over all the tables in the model, maybe there is some corner case that it is not getting date range to create the calendar dimension. You can always get the min and max date from the sales table and then use the CALENDAR function to create the table.

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡