Calculate XIRR

[Ashish Mathur]

Hi,

I would like to calculate XIRR in PowerBI Desktop using a measure. I have posted the question here as well. Using these DAX functions, i have made some progress but as you can observe, the inputs in the DATATABLE function are hard coded and i would like to replace those with measures that i have written.

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 the 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.