XIRR funtion couldn't find a solution

[SelinaHK]

Hi all,  I have two datasets: one of them can't calculate XIRR (see picture 1) and another one can calculate(see picture 2).
Do you know the reason? I have serached in the Power BI Community and still can't find the reason (mainly point to small start value etc). Appreciate any comments  

[OwenAuger]

Hi @SelinaHK 

I can't seem to replicate your issue.

I loaded the data from the two screenshots (into a single table for simplicity) and created a simple measure with XIRR. This measure returns an IRR of 12.8% for the "Contribution" values (and 37.5% for the Payment values). I checked this in Excel as well and get the same result.

IRR Measure = 
XIRR (
    Data,
    Data[Amount],
    Data[Date],
    , -- Guess omitted
    "Error" -- Optional value to return in case of error
)

I have attached my PBIX in case it helps to compare.

Could you provide more detail of the IRR measures you have created and the data model?

Regards,