Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
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.
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:
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.
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |