PY

Category: Compare periods

Overview

Description

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

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

Syntax

PY('Node')

Parameters

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

Each value appears one year later in the result.

Input node: Profit

Formula: PY('Profit')

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

Input node: Profit

Formula: PY(PY('Profit'))

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