Forum Discussion
Solved
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 fro...
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!