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') |
Examples
Shifting values by one month
Each value appears one month later in the result.
Input node: Profit
| Month | Value |
|---|---|
| 2025-01 | 35 |
| 2025-02 | 42 |
| 2025-03 | 47 |
Formula: PM('Profit')
| Month | → PM Result |
|---|---|
| 2025-02 | 35 |
| 2025-03 | 42 |
| 2025-04 | 47 |
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
| Month | Value |
|---|---|
| 2025-01 | 35 |
| 2025-02 | 42 |
| 2025-03 | 47 |
Formula: PM(PM('Profit'))
| Month | → PM Result |
|---|---|
| 2025-03 | 35 |
| 2025-04 | 42 |
| 2025-05 | 47 |
Related Functions
| 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. |