Parallel Day

The Parallel Day functions (blue highlight below) are exposed in the Time Intelligence wizard when a dateKey hierarchy is selected and the level type is set as Date (red highlight). These functions return a list of two dates: the given date and the same date in the selected parallel period. For instance, if a Month on Month list is added to the query, and March 3, 2019 selected from the parameter, the query will return both March 3, 2019 and February 3, 2019.

Parallel Day functions generate the following elements:

  • A parameter, which is used to inject a date into the query at runtime.
  • Percentage difference custom calculations, which return the percentage difference between the given date and the parallel date.
  • Custom lists, which return both the given date and the parallel date.