Reference Previous Values
Syntax:
previous(InitialValue, [Table.Column])
References the previous value within a table. The first argument is the initial value, and if you want to reference the previous result in another column, you can pass its name as the second argument.
Examples
previous($10) + 5%
adds $10
to the first row and adds 5%
to each subsequent row, taking into account the previous value.
previous(0, Acquired * 5%)
forecasts the number of customers who churned based on the previous year's acquired clients and a 5%
churn rate.