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/
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.