SSAS Tabular Part 6 : Create Calculated Columns

A calculated column is a column that we add to an existing tabular model table. Instead of pasting or importing values in the source database column, we create a DAX formula that defines the column values.

For Example, I am taking Date table and going to add a calculated column named QuarterDescription after CalenderQuarter.

AIM: In this calculated column, we have to fill Quarter name as per "CalenderQuarter" column value. Calculation scenario given below.

Steps to create QuarterDescription column:

• Click on 'Grid View' Panel (Bottom Right Corner).
• Click on Date Table. Scroll right in date table until CalenderQuarter comes.
• Right click on next column header of CalenderQuarter and click on ‘Insert Column’.(Now we can see one column with default name is created just right of CalenderQuarter column )

• Now change the header of the column by double click on it and give name as QuarterDescription.
• In the formula bar above the table, type the following DAX formula given below

           =SWITCH([CalendarQuarter];1;"First Quarter";2;"Second Quarter";3;"Third                      Quarter";"Fourth Quarter") 

• After paste the formula, press ENTER.