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
4 Replies
Hi Anonymous,
there must be no gaps in the dates in order to be able to Mark a table as 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 ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
