Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
Vicky,
I appreciate the fast response. The DAX for my "Work Calendar" is
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
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.
You can try use the CALENDARAUTO() function which should automatically refresh based on the date range present in your data set.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |