Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |