Additive Calculated Columns

Here we will calculate the number of Expected Delivery Days.

  1. Right-click on the OrderDetails table and select New column. Select OrderDetails

  2. Enter the following DAX then hit Commit:

Expected Delivery Days = DATEDIFF ( OrderDetails[OrderDate], OrderDetails[ExpectedDeliveryDate], DAY )

DAX A square icon with a sigma symbol should appear next to the name.
Sigma
This calculated column will give us the number of Expected Delivery Days at the row level. This by itself isn’t a very useful analytical attribute, however, the average Expected Delivery Days would be useful.

We’ll set up calculated column properties in the next step.

  1. Click on the Expected Delivery Days so it is highlighted in a grey shade. [Click Expected Delivery Days

  2. Under Column Tools, Change the Summarization: Sum to Average. Change Default Summarisation to Average