Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
I disabled my source table from refreshing to realign some columns into an order I wanted in my data table and in doing so the date table which was operating on calendarauto() reverted from >2022 to 1899. This adds ~45k rows of uneeded dates.
Even upon reconnecting its maintained, I checked the rleationship and even tried changing the function to calendar with a defined range. No love.
Any help would be great, cheers.
Solved! Go to Solution.
The cause is probably a null or 0 value in a date column somewhere. To fix it, you can either filter / clean your data so that it doesn't have such values. Or, you could try and use the regular CALENDAR() function, which would look something like:
Calendar Table = CALENDAR(DATE(YEAR(MIN(Table[Dates])), 1, 1), DATE(YEAR(TODAY()), 12, 31))
Brilliant thank you!
The cause is probably a null or 0 value in a date column somewhere. To fix it, you can either filter / clean your data so that it doesn't have such values. Or, you could try and use the regular CALENDAR() function, which would look something like:
Calendar Table = CALENDAR(DATE(YEAR(MIN(Table[Dates])), 1, 1), DATE(YEAR(TODAY()), 12, 31))
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
68 | |
53 | |
53 | |
36 | |
34 |
User | Count |
---|---|
84 | |
71 | |
55 | |
45 | |
43 |