Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
stuart765
Frequent Visitor

Calendar Table Not Refreshing

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.

 

 

1 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

Microsoft Employee

View solution in original post

4 REPLIES 4
stuart765
Frequent Visitor

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 

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

Microsoft Employee

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_
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors