Recursive Calculations in Power BI

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.