⚠️ Important
This function is scheduled for removal by Q2 2026. Its replacement, PREVIOUSOF is now live. Any customers needing help to switch to PREVIOUSOF will be migrated in a phased approach. We will reach out over the next few months.
Description
Returns the value of the previous cell in the iteration Dimension of the base Metric, as defined in the iterative calculation configuration.
This function allows you to create multi-Metric iterative calculations.
For more information on how to create iterative calculations involving multiple Blocks, see Iterative Calculations Across Multiple Blocks using PREVIOUSBASE.
Syntax
PREVIOUSBASE()Arguments
Not applicable.
Returns
Type | Dimensions |
|---|---|
Same as the Base Metric | Same as the Base Metric |
Examples
Formula | Description |
|---|---|
| Returns the previous month value of the Base Metric with Month selected as Iteration Dimension. |
Equivalent in Pigment: 'Base Metric'[SELECT: 'Iteration Dimension' - 1]
See Also
Excel: no equivalent
Related articles: