Forum Discussion

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago
Solved

Calculate XIRR

Hi, My objective is to calculated the XIRR as of 31 January 2023 using a measure.  These are my measures   Purchase date of shares = MIN(Shares[Date of Purchase]) Cost of shares (Rs. cr) = ...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Not sure why I get 27.44% but here's my version.

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Thank you very much for your reply.  That solution works.

lbendlin's avatar
lbendlin
Super User
3 years ago

Any idea why I got a different number?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    The date and month were interchanged.

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      D'oh!  Sorry about that.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

        Hi lbendlin ,

        I am stuck at calculating the XIRR at the aggregate level.  I have given a detailed description in the attached file.  Could you kinldy modify my XIRR formula to get the correct figure at the aggregate level.

        Thank you.