Ginger Grant shows how to build a dynamic date dimension in Power BI using either DAX or M:
Recently I needed to create a date dimension for a Power BI model as there was not one in the source database. There are two different ways that I could do this, using DAX from the Modeling Tab within the Data View or using M via the Query Editor window. As a general rule, when it is possible data manipulation should be done in M as it offers a greater level of compression. In this case though I am using a function in DAX, which is not the same as creating a calculated column.
Read on to see code examples for each method, as well as Ginger’s analysis.