Forum Discussion
Date table
Hi, what is the error? What change should I make?
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi AtchayaP ,
Could you please share the snapshot of your date table which you tried to mark as date table. For creating date table for your model please refer below article.:-
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
Thanks,
Samarth
A date table needs to have one row per day and contain an unbroken sequence of dates.
eg if you have 1-Feb-2022 and then skip to 3-Feb-2022 you'd get that error.
- I got the dax measure for my date table , but while using it in table visual I'm getting date and year in column, but for example if I use line chart year with other colnumn, I'm not getting the right visual,does it mean I did mistake in DAX
Are you able to share a pbix file. Really need some example data and expected outcomes in order to help.
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
