Forum Discussion
Date Table
Hello all, I keep getting a message when setting the calendar table as date table, that there is room between the dates. What am I doing wrong? this is my date table
Hi Anonymous ,
Why not create a calculated table like this and mark the table as date table?
Table = CALENDARAUTO()
As the online document.
When you specify your own date table, Power BI Desktop performs the following validations of that column and its data, to ensure that the data:
- contains unique values
- contains no null values
- contains contiguous date values (from beginning to end)
- if it is a Date/Time data type, it has the same timestamp across each value
Regrds,
Frank
Hi Anonymous ,
Why not create a calculated table like this and mark the table as date table?
Table = CALENDARAUTO()
As the online document.
When you specify your own date table, Power BI Desktop performs the following validations of that column and its data, to ensure that the data:
- contains unique values
- contains no null values
- contains contiguous date values (from beginning to end)
- if it is a Date/Time data type, it has the same timestamp across each value
Regrds,
Frank
Great thanks