Forum Discussion
teolachev
Helper II
Helper IIHow 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/
desertislesql
Most Valuable Professional
Most Valuable ProfessionalDoes this mean that if we need to do Date Calculcations with DAX we should model in Power Pivot in order to be able to include them in our reports?
desertislesqlMost Valuable Professional
Most Valuable ProfessionalIf you are interested in how to create a marked date table in Power BI which can use all the DAX time functions, this post should help http://www.desertislesql.com/wordpress1/?p=821