Forum Discussion
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) = ...
Not sure why I get 27.44% but here's my version.
Hi,
I have made some progress. I wrote the following 2 DAX formulas:
Calculated table formula
Table 2 = DATATABLE("Period",DATETIME,"CF",CURRENCY,{{"01/11/1999",-1.41},{"31/01/2023",397.12}})
Measure
XIRR of shares = XIRR('Table2',[CF],[Period])
I get the correct XIRR result i.e. 26.41%
The modification that i wish to bring here is that i would like to replace hard coded entries in the DATATABLE function with measures that i have written. I'd like
1. 01/11/1999 to be replaced with the measure [Purchase date of shares]
2. -1.41 to be replaced with the measure [Cost of shares (Rs. cr)]
3. 31/01/2023 to be replaced with the measure [Selected period]
4. 397.12 to be replaced with the measure [Market value of shares (Rs. cr)]
How can i do this?
Thank you for your help.