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