Date table advantages

Hi AndrejZevzikov 

(1)When you use Date Hierarchy in the visual , the users have to drill down to month from year every time , most of the time, this operation is unnecessary .When the date table is marked as date, the Date hierarchy table is removed for Date within the Date table,this saves space and you can simply create your own date hierarchy to work with .

(2) We can get rid of inaccurate values when we deal with time intelligence functions .

I found some blogs to help you better understand the function .

https://debbiesmspowerbiazureblog.home.blog/2020/07/29/power-bi-why-marking-a-date-table-is-a-good-thing/

http://nisalbi.blogspot.com/2018/08/mark-as-date-table-in-power-bi-what-and.html

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables

Best Regards

Community Support Team _ Ailsa Tao

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