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.
