Forum Discussion

AbhinavD's avatar
AbhinavD
Frequent Visitor
7 years ago

Building a dynamic IRR (using the XIRR function) model based on a WhatIF parameter

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 cha...
Need Help
TeigeGao's avatar
TeigeGao
Solution Sage
6 years ago

HI AbhinavD ,

For the whatif scenario, we can use the calculate() and filter() function to get the result.

Best Regards,

Teige

  • AbhinavD's avatar
    AbhinavD
    Frequent Visitor
    6 years ago

    Teisi thanks for your input. 

    I tried doing the same, but I cant picture how this would work.