Forum Discussion
Solved
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.
- 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.