Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

IRR POWER BI

Hey!

 

I need to find a measure that could calculate de IRR beside the XIRR.

Thank you.

 

Best regards.

DAX
dax measure

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Icon for Super User rankSuper User
    7 years ago

    Hi Anonymous 

     

    What's your reason for avoiding the XIRR function? I'm aware that it doesn't handle errors well but that can be worked around.

     

    You could create a table of candidate IRR values then iterate over that table to find which one gives the NPV closest to zero (using XNPV if you are happy to use that).

     

    Regards,

    Owen