CALENDARAUTO displays dates from 1899 with refresh table that only uses dateTime.LocalNow()

[jdogcisco]

Hi Awesome People,

I'm using CALENDARAUTO to create a Calendar table and this works well in creating dates that align with my data.

Now, however, I added a 'data refresh' table so I can display the last refresh date of the dashboard. *Note, I did try changing the DateTime column from 'any' to DateTime and I get the same results. I've also changed it to Date and I get the same results.

After adding this table, CALENDARAUTO now thinks dates go back to 1899...

Why does this happen when there is only one entry in the Data Refresh table?  I could switch to CALENDAR and use min max on my data's dates, but that would mean updating A LOT of visuals that is already using the Calendar table....and that doesn't really address the issue, just supresses it.

Any thoughts?

[ArT101]

you could also change the data type to TEXT and that works as well

[Teo1967]

This happens because you must have some time column in one of the tables.

The alternatives are:

1) Delete the time column or
2) Create the Calendar table by Power Query (which I recommend)

[AlexisOlson · Accepted solution]

I don't like to rely on CALENDARAUTO for this sort of reason. If you change the definition to CALENDAR, you shouldn't need to update any visuals since they'd be using the same column (it's just defined differently).

My guess is that it's interpreting the Time column as DateTime for some reason. Maybe try converting that column to decimal just to see if that's indeed what's going wrong.

[jdogcisco]

Huh, go figure. That (switching Time column to decimal) fixed the problem.  Thank you!