To create Date Dimension in SSAS Tabular model

 Hi All,

To create date dimension in SSAS tabular model

Click on calculated table and then paste the below in the formula

=CALENDAR ("1/1/2015","1/1/2030")

And then give the date table your name and follow the below steps to make it effective

In Visual Studio, in the model designer, click the date table.

Click Extensions > Table > Date > Mark as Date Table.

In the Mark as Date Table dialog box, in the Date listbox, select a column to be used as a unique identifier. This column must contain unique values and should be of Date data type.

If necessary, create any relationships between fact tables and the date table.