PM

Category: Compare periods

Overview

Description

Shifts the input node Node one month into the future while retaining all other dimensions.

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

Syntax

PM('Node')

Parameters

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

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

Function	When to use instead
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.