Calculate the Time Interval Between Two Dates

Create a calculation that shows the time interval between two dates.

Prerequisites

Your model must have Date columns or date (time) hierarchies with Day level granularity.

Procedure

  1. Select your chart.
  2. In Builder, choose Start of the navigation pathAdd Measure Next navigation step Calculations Next navigation step Create CalculationEnd of the navigation path.

    The Calculation Editor dialog appears.

  3. Select Date Difference from the list.
  4. Enter a name for the calculation.
  5. In the Properties section, select values for Result Granularity, Time (A), and Time (B)

    The Result Granularity values are determined by the data source: if the data source does not contain quarters, you won't see them in the list of values.

  6. Select OK.

    The date calculation is added to the chart.

  7. Add dimensions to your chart.