Forum Discussion

Nagesh20's avatar
Nagesh20
Icon for Helper I rankHelper I
2 years ago
Solved

Calculate XIRR from two tables

Hi all,   Trying to calcaulate XIRR from the below two tables. It woud be helpful if anyone can provide the right DAX formula.   Getting IRR in excel is 17.13%   Cashflow table Date           ...
Need Help
  • AmiraBedh's avatar
    AmiraBedh
    2 years ago

    Try the following :

     

    IRR2 = 
SUMMARIZE(
    Transactions_All,
    Transactions_All[Fund],
    "IRR", [Your_IRR_Calculation_Measure] // I assume you have a measure that calculates IRR
)
AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
2 years ago

You forgot to share the formula 🙂