Search Results

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. On the menu bar, click Data > Add calculated column.
  2. In the Add calculated column dialog, type the expression of interest.
    For more information about which types of methods you can use, see Functions and Operators.
    Tip: When you start typing, autocomplete functionality will suggest names of functions or column names, matching those characters you have written. Click a suggestion, and it will be added to the expression.
  3. Beneath Column name, give the added column a proper name.
  4. Click OK.