PREVIOUS function

Description

Previous is an iterative computation that allows filling the cells with the previous value following a specific Dimension (generally a time Dimension).

The function references another cell of the same Metric previously computed by the same formula or the user input when the override is activated.

Syntax

PREVIOUS(Dimension, [Offset])

• Dimension of the current Metric on which we would like to apply an offset

• Offset is an integer N that allows to return the Nth value before. By default the value is 1

Return type

Same as Metric

Examples

Example 1

Example 2

Using the Annual Rise Property of the Product Dimension and initial price for a specific year, Previous function allows us to calculate Product annual price.

Product price with inputed values for FY20:

The formula calculates all the following values for FY21 and FY22:

For more examples, check