PM

In Compare periods

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')

Examples

Shifting values by one month

Each value appears one month later in the result.

Input node: 'Profit'

Formula: PM('Profit')

Shifting values by two months (nested PM)

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'))

See also

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.