DAX 101: Creating a simple date table in DAX
A date table is required for most time intelligence calculations such as year-to-date, previous year or moving averages. If a data model does not already have a date table, it is possible to create one using a calculated table and some basic DAX code.
The date table needs to follow a few rules: