Date Table

[Anonymous]

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

 

[v-frfei-msft · Accepted solution]

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

[Anonymous]

Great thanks

[v-frfei-msft]

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

[LivioLanzo]

Hi @Anonymous,

there must be no gaps in the dates in order to be able to Mark a table as Date Table