Forum Discussion
PowerBI XIRR vs Excel XIRR differences
Afkkek ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Hope you are using https://learn.microsoft.com/en-us/dax/xirr-function-dax
https://www.youtube.com/watch?v=N1WRSFuaFmE
Appreciate your Kudos.
Thanks for the reply amitchandak , I'll try to explain it with some screenshots.
Here you can see that for a given set of cash flows, Excel calculates either 28.39% (default estimate) or 593% if a higher estimate gets entered - in my case here I've entered 200% arbitrarily.
PowerBI on the other hand using the exact same cash flows with default estimates, gives the 593% result.
Even if I manually hard code the expected 0.28 estimate in, it still gives 593%.
Is this something that's expected, and has anyone managed to get around it?