Add Calculated Column

In the Cached Dataset, you can add the WAX field functionality on the dataset designer by using the Add Calculated Column option. Calculated Columns are used to perform complex arithmetic calculations on your data. They enable you to build new data from the existing data, with the help of analytical expressions. An analytical expression consists of functions, operators, and value references, which are evaluated as a formula to generate results.

In general, calculated columns are used to perform row-by-row calculations on the entities.

To Add a Calculated Column

Consider a dataset that contains information related to Products, Unit Price, and Quantity. We can use this dataset to calculate the Total Amount for the products using the following analytical expression.

'Current_Dataset'[Unit price]*'Current_Dataset'[Quantity]

Follow the steps below to add a measure with the above expression.

1. On the Fields tab, click the More option and select the Add Calculated Column option from the list.

   
   

   
   

   Note: On the Fields tab, you will see the More option in the Detail mode.

   Add Calculated Column dialog box is displayed.

   
   

   
   

   
   

2. In the Add Calculated Column dialog box, enter the name and expression for the new column.

   
   

   
   

   
   

3. Click the Add button.

   
   

   The calculated column now appears under the Analytical Expression Fields.

   
   

   
   

   
   

   So now the dataset supports storing the WAX expression, and you can use this in the dashboard designer.

   Note: You can create a WAX expression in the Cached Dataset Designer only and not in other types of dataset designers.