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
Example 1
Example 2
Using an annual rise property of Product dimension and inital 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:
Comments
0 comments
Please sign in to leave a comment.