Forum Discussion
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.
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))
2 Replies
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))
