Forum Discussion
Date Table
Hi, koorosh
'Mark as a date table' most of the time is to use the time intelligence functions. In fact, it is not suitable for newcomers if you need the date hierarchy. As you can see, you can’t use a default hierarchical structure to display data in visual.
If you want to create your own date table and define your own date hierarchy, you can mark as a date table.
Set and use date tables in Power BI Desktop - Power BI | Microsoft Docs
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.Best Regards,
Community Support Team _ Janey
koorosh in Image 2, when you didn't mark as date table, Power BI automatically created a date hierarchy for your date column.
That is what this setting in Options>Global>Data Load does:
Typically it is not recommended that this approach be used. Rather, it is best practice to build a date table that has the month, year, quarter, etc. columns that you need.
Thanks ebeery, So when using Mark as Date Table would be useful? Or where it would be useful since you wrote " it is best practice to build a date table that has the month, year, quarter, etc. columns that you need".
Regards
