XIIR since inception to diferente dates

[Caraneda]

Hi,

I've a database with similar to this:

Cashflows Spreadsheet 

And I'm trying to generate a measure to visualize the XIIR evolution to each unrealized cashflow.  That means I need the XIRR formula only considerer the last NAV until the date I'm consulting that time. Aditionally I'll like to been able to simulate the XIRR of a portfolio if I had those funds, whichs implies I need tu sum the last NAV in that case.

Can enyone help me?

Thanks!

Can anyone help me?

[v-eqin-msft]

Hi @Caraneda ,

About XIRR() DAX, please refer to:
XIRR

Power BI XIRR or IRR (Internal Rate of Return) function

A similar thread:

https://stackoverflow.com/questions/56778279/how-can-i-fix-dax-xirr-calculation-for-projects-with-di...

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.