To add Calculated Columns to a Tabular Model:
- Go to the Fact table's relevant column properties' screen to set the following fields:
- Column name: "combined_tax".
- Business Display Name: "Combined Tax".
- Type: Column.
- Click the Transformation tab and select the following:
- After Load as the Transformation Stage.
- Default DAX as the Function Set.
- Add a SUM and select the tax amount columns from the list of available columns on the right.
- Click OK on the fact column transformation screen.
Note
Microsoft Analysis Services 2005+ Tabular Mode Tables: For Tabular Mode table column transformations, Default DAX is the only applicable Function Set for after load transformations.
- Right click the table fact_order_detail_tabular from the left pane and then select Create(Recreate) .
- After the table has been recreated, right click again and then select Update to update the table.