Adding a calculated column

Calculated columns allow you to combine or recalculate one or more columns with aggregation measures and/or mathematical expressions. This way, you can create new columns with more information based on your available data.

Procedure

  1. In the Data panel, click on the column of interest and click on the Expand data panel for tools and details button, Expand data panel for tools and details..
    If a single column was selected in the Data panel, you may need to click on the Go to data table view link to see the data table view.
  2. In the data table view of the expanded data panel, click on the Add calculated column button to the right.
    Add column from expression.
  3. In the Add calculated column dialog, type the expression of interest and click OK.
    For more information about which types of methods you can use, see Functions and Operators.