The PREVIOUSVERSION function evaluates the given expression using the previous version.

For example, you can use the PREVIOUSVERSION function to make comparisons between data from different versions of a plan.


ArgumentData typeDescription
ExpressionNumber, Boolean, date, time period, list, or textThe expression to return the value from the previous version for.

The PREVIOUSVERSION function returns a result of the same format as the Expression argument.


In this example, the formula returns the value from the previous version of the Bonus line item.

The order of versions is from top to bottom in Versions in the model settings bar.

For example, if your model's versions are ordered Budget, Actual, and Forecast, the previous version of Actual is Budget.

The result cell that you use the PREVIOUSVERSION function in must use Versions as a dimension.

In this example, an income statement module has line items on rows, time on columns, and versions on pages. The model has three versions: Budget, Actual, and Forecast, in that order. The page selector is set to the Actual version.

The formula in the Budget Cost of Goods line item uses the PREVIOUSVERSION function to retrieve the value of Cost of Goods from the previous version. 

Jan 21Feb 21Mar 21
Cost of Goods198,734236,761200,459
Goods Sold456,987498,705460,983

Budget Cost of Goods