Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @sv12 ,
Hope this third - part blog can help you.
https://exceleratorbi.com.au/compound-growth-using-dax/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |