Forum Discussion

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper 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.

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

D'oh!  Sorry about that.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper 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.