Calendar Auto function has reverted date table to 1899

[L_R_S_85]

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.

[L_R_S_85]

Brilliant thank you!

[vicky_ · Accepted 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))