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/
Thanks greggyb. Yes I was aware of the "remove time filter context" that comes from Mark as Date Table and the syntax sugar approach. I was not aware of the "use any key to join the tables but then have a different date column for the time intelligence" difference between Excel and Power BI (although I figured there must be a difference given the lack of a "mark as date table" in Power BI).
I have always felt that the "mark as date table" is superfluous. Every single inbuilt time intelligence function requires you to specifiy the Calendar[date] column in the measure. So it seems to me that you need to tell Power Pivot 'twice' which is the date column. Surely if you "mark as date table" then you shouldn't need to specify the date column in the time intelligence function. I assume that no other date column from any other table will work, so that would not be an option.
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/
