Creating a date table in Visual Studio
Most models you will create need to have a date table to use for calculating and summarizing data over time. Using DAX functions, you can create a customized date table to add to your model. By leveraging many of the date functions included in DAX, you can extend the columns to make the model easier for end users to leverage. The DAX time and date functions leverage the date table to perform the calculations, without it your time and date functions will not work properly.
Getting ready
To complete the recipes in this section, create a new Visual Studio project and import the CRASH_DATA_T table from the Crash_Data_DB database. This table has the CRASH_DATE column, which contains the date for each record crash. You will use this table as the reference to create a new date table in the model.
In this recipe you will create a date table that is built by using a DAX formula and the calculated table functionality of tabular models.
How to do it...
In Visual Studio...
