Forum Discussion
Date table advantages
(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 .
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.
(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 .
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.