Tabular Model Calculated Columns

To add Calculated Columns to a Tabular Model:

1. 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.
   
2. 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.

3. Right click the table fact_order_detail_tabular from the left pane and then select Create(Recreate) .
4. After the table has been recreated, right click again and then select Update to update the table.