Forum Discussion
How to mark Date table?
You can also use PowerQuery itself to create a date table. Matt Mason has a great post on this here - http://www.mattmasson.com/2014/02/creating-a-date-dimension-with-a-power-query-script/
As of 2017, is it supposed to mark as a Data table? Where is the menu option?
Regards
This is not required/possible in Power BI. If you want to use a calendar table, you must use a date field and join on that. Then it will work as designed. In Power Pivot for Excel you can use a surrogate key. In this case you must mark as date table.
The Mark As Date Table feature has been implemented in February 2018 version.
You can use the workaround described in this article to mark a table as a Date table in Power BI:
https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/
