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.
dimensionof the current metric on which we would like to apply an offset
offsetis an integer N that allows to return the Nth value before. By default the value is 1
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: