Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

XIRR return error.

  Hi I have these two sets of data in Excel, which return legit IRR. May I know why is it not working in powerbi?                                                      ...
Need Help
MFelix's avatar
MFelix
Super User
2 years ago

Hi Anonymous ,

 

Not sure why but your issue is with the first value of the divided by 1000, it seems like the value is to low. made some tests and removing the value or making it above -51 it works properly.

 

Don't know why this is ocurring but maybe you can add a post in the issues part of the forum.