Recursive Calculations in Power BI

[Anonymous]

Hi,

I am trying to recalculate the attached excel sheet in Power BI. This involves a recursive calculation (for column $ Withdrawal) and I was wondering if I could get some help in the DAX part.

Sample Data File: https://drive.google.com/file/d/1UG8fqMivXgNRGVTpIyRduUrbCWaLfguQ/view?usp=sharing

1. The Raw data would be the attached excel file with columns: Date, Days in Month, Month End NAV and Inflation rate. (Not $ Withdrawal)

2. I need to recreate the column "$ Withdrawal" in Power BI. This is where I need some help with DAX.

(Please refer to the formula in excel file for the column "$ Withdrawal")

3. For this Calculation, I would like to have the user enter the Parameters: "Start Date, Inflation Value and Withdrawal Rate" in Power BI.

Please let me know if you need more information.

Thanks for the help.

[v-frfei-msft]

Hi @Anonymous ,

Hope this third - part blog can help you.

https://exceleratorbi.com.au/compound-growth-using-dax/