Power BI Exchange

Hello

I need the current accrual by adding the current value to the previous accrual multiplied by a growth rate:
X_Acum = X + (X_Acum previous year * (1 + Rate_Growth_Y))

To illustrate, the attached yellow excel column shows the obtained value.

Excel here

------------------------------
Vilmar Santos
------------------------------

------------------------------
Vilmar Santos
------------------------------

Original Message:
Sent: Jun 11, 2022 05:20 PM
From: Vilmar Santos
Subject: Accumulated With Percentage

Hello

I need the current accrual by adding the current value to the previous accrual multiplied by a growth rate:
X_Acum = X + (X_Acum previous year * (1 + Rate_Growth_Y))

To illustrate, the attached yellow excel column shows the obtained value.

Excel here

------------------------------
Vilmar Santos
------------------------------

Hi,
You can find a solution in the attached file.
If this solution is what you are looking for, please mark it as a Best answer.

------------------------------
Hoss Satour
Data analyst
Algiers - DZ
numidiabi.wordpress.com
------------------------------

Original Message:
Sent: Jun 11, 2022 05:20 PM
From: Vilmar Santos
Subject: Accumulated With Percentage

Hello

I need the current accrual by adding the current value to the previous accrual multiplied by a growth rate:
X_Acum = X + (X_Acum previous year * (1 + Rate_Growth_Y))

To illustrate, the attached yellow excel column shows the obtained value.

Excel here

------------------------------
Vilmar Santos
------------------------------