Downloads
DAXTime intelligence: shift and compareIntermediate

PARALLELPERIOD

Returns the whole parallel month, quarter or year, shifted by a number of intervals.

Syntax
PARALLELPERIOD(<dates>, <number_of_intervals>, <interval>), where interval is MONTH, QUARTER or YEAR

Returns: A table of dates.

What it does

PARALLELPERIOD takes the visible dates, finds the full period they belong to, and moves that whole period by a number of intervals. Where DATEADD moves only the visible days, PARALLELPERIOD moves the entire month, quarter or year. Finance teams use it to compare a partial period, such as the month to date, with the whole of the prior period, or to read a full prior year next to the current year to date.

Syntax and arguments

Example

The sales team wants the month-to-date revenue for October 1 through 15, set against the full revenue of September, as a benchmark for the whole month.

Revenue Full Prior Month =
CALCULATE([Total Revenue], PARALLELPERIOD('Calendar'[Date], -1, MONTH))

In a view of October 1 through 15, the measure returns all of September, not only September 1 through 15. Set it next to Revenue MTD to see how the current month is tracking against a full prior month.

Example: a second, different use

The full prior fiscal year, as a benchmark for the year to date. The measure returns the whole of the prior year even while the current year is partly complete.

Revenue Full Prior Year =
CALCULATE([Total Revenue], PARALLELPERIOD('Calendar'[Date], -1, YEAR))

Things to watch

In business terms

PARALLELPERIOD is used when a team wants a benchmark that is a full period: the last full month for a flash report, or the full prior year for a growth benchmark. It keeps the question clear, because the comparison is the whole of the other period.

Related functions

All DAX functions · View as Markdown · DAX fundamentals