Which three actions should you perform in sequence?

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to add a calculated column to a table in the model.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

Answer: See the explanation.

Explanation:

Box 1:

Box 2:

Box 3:

Note:
* To create a new calculated column
1. In the model designer, in Data View, select the table to which you want to add a
calculated column, then click the Column menu, and then click Add Column.
Add Column is highlighted over the empty rightmost column, and the cursor moves to the
formula bar.
To create a new column between two existing columns, right-click an existing column, and
then click Insert Column.
2. In the formula bar, do one of the following:
• Type an equal sign followed by a formula.
• Type an equal sign, followed by a DAX function, followed by arguments and
parameters as required by the function.
• Click the function button (fx), then in the Insert Function dialog box, select a category
and function, and then click OK. In the formula bar, type the remaining arguments and
parameters as required by the function.
3. Press ENTER to accept the formula.
* Calculated columns, in tabular models, allow you to add new data to your model. Instead of
pasting or importing values into the column, you create a DAX formula that defines the
column’s row level values. The calculated column can then be used in a report, PivotTable,
or PivotChart as would any other column.
* A calculated column is DAX expression that creates a new column in a table and the
obtained values are stored in the table; the calculated column expression is evaluated every
time the table is processed.
* In tabular object models the calculated column is a column in a table whose values are
calculated upon definition of the column, from an expression.
Reference: Create a Calculated Column (SSAS Tabular)