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.
Need some help building an IRR model in Power BI desktop.
I need to make it dynamic, where the user can select how much to add/subtract from the Initial Equity invesment and see the resultant change in IRR. the data looks like this:
I am currently using the XIRR function to calculate IRR.
HI @AbhinavD ,
For the whatif scenario, we can use the calculate() and filter() function to get the result.
Best Regards,
Teige
@Teisi thanks for your input.
I tried doing the same, but I cant picture how this would work.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |