PM

PM('Node')

The PM function shifts the input node one month into the future while retaining all other dimensions.

Use this function when you need last month’s values alongside current data for month-over-month comparisons.

Parameters

NodeNode referenceRequired: Input node that is shifted, specified using the node name in single quotes (e.g. 'Profit')

This function is only available on projects that use the month time dimension. A project has either Year, Quarter, Month and Day or Iso-Year, Week and Day, never both, so on a week-dimension project the node fails with an error saying the Month level could not be found. The time dimension is chosen per project, see Project Settings.

Each value appears one month later in the result.

Input node: 'Profit'

Formula: PM('Profit')

Nesting PM calls shifts values further into the future. Here, each value moves two months forward. Try SHIFT as an alternative with a custom offset.

Input node: 'Profit'

Formula: PM(PM('Profit'))

PQ: When you need the previous quarter instead of the previous month.
SHIFT: When you need a custom offset or want to shift along a specific time level.
MOM_ABS: When you need the absolute difference to the previous month, not just the shifted values.