Forum Discussion
Solved
How to mark Date table?
How do we mark a Date table as such in Power BI Desktop so that DAX date formulas, such as TOTALYTD, work?
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/
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.
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/
The Mark As Date Table feature has been implemented in February 2018 version.