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

Join 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.

Reply
L_R_S_85
Regular Visitor

Calendar Auto function has reverted date table to 1899

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.

 

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

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))

 

View solution in original post

2 REPLIES 2
L_R_S_85
Regular Visitor

Brilliant thank you!

vicky_
Super User
Super User

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))

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.