Forum Discussion

AtchayaP's avatar
AtchayaP
Helper V
4 years ago
Solved

Date table

Hi, what is the error? What change should I make?  
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi AtchayaP ,

    There are some limitations about Mark as date table.

    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

    Please check whether your date column is contiguous.

    Reference: Set and use date tables in Power BI Desktop - Power BI | Microsoft Docs

     

    Best Regards,
    Community Support Team _ kalyj

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.