Calendar Table Not Refreshing

[stuart765]

Calendar(s) that I imported from Excel into Power BI always refreshed with my data table when I clicked the "Refresh" button. I created a new calendar within Power BI and that table does NOT rerfresh when I refresh my data table. Will my calendar table dates update and will my data table refresh with updated data if I just change the "End Date" in my Calendar query to a later date? Are you aware of an alternate way to refresh the calendar table? I appreciate all the past assistance.

Thank you.

[stuart765]

Vicky,

I appreciate the fast response. The DAX for my "Work Calendar" is 

Work Calendar = CALENDAR("1/1/2020", "12/31/2023"). Should I update it to Work Calendar = CALENDARAUTO("1/1/2020", "12/31/2023") and then only have to update "12/31/2023" when necessary?

Thanks again 

[ppm1 · Accepted solution]

Your CALENDAR function has fixed dates in it. To get a dynamic calendar, you need to use a different approach. Two examples below:

To have it match one of the date columns in your model

CALENDAR(MIN(FactTable[Date]), MAX(FactTable[Date]))

To have a fixed start but expand with each daily refresh

CALENDAR("1/1/2020", TODAY())

Pat

[stuart765]

Pat,

Thank you for the fast response. Our dataset is refreshed weekly and I will try that date and/or CALENDARAUTO.

Thanks again to all for the fast response.

[vicky_]

You can try use the CALENDARAUTO() function which should automatically refresh based on the date range present in your data set.