XIRR produces different results in Power BI than Excel. XNPV matches though
I got an error trying to calculate xirr:
MdxScript(Model) (1,42) Calculation error in measure
... The XIRR function couldn't find a solution
The same set of cashflows produce a number in Excel -
XNPV works in both cases but it looks like the root finder is not converting in Power BI but it works find in Excel
I had a similar problem.
The XNPV on Power BI, is different of PV on Excel.
How can I calculate this value correctly?