How can we improve Power BI?

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

1 vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Hi,

    I had a similar problem.

    The XNPV on Power BI, is different of PV on Excel.

    How can I calculate this value correctly?

    Thank you

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.