Forum Discussion
Aggregate XIRR Calculation Help
Hi Anonymous,
If these solutions do not resolve the issue, please consider raising a Microsoft support ticket. You can create a Microsoft support ticket using the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Thank you.
Hi Anonymous
Thank you for sharing the required details. I have reviewed the PBIX file and verified that the XIRR calculations are working as expected. Could you please specify your expectations for the output? This will help us provide the most accurate solution at our earliest convenience.
Thanks for your understanding and have a great day a head.
Linked below is an excel with the expected outcome if the following accounts were selected for the Aggregate XIRR:
A458B672
E090
The XIRR calculation in PowerBI is only giving me -100% while I am getting the expected results in excel.
Hello,
After conducting several workarounds to resolve the issue, we discovered that the data in the calcashflow column is in an incorrect format, specifically using parentheses “( )”. This format causes the values within the parentheses to be interpreted as negative, leading to invalid IRR results. Consequently, we suspect this may be causing the XIRR function to return an error.
Therefore, we recommend modifying the data accordingly and checking if the outcomes reflect as expected.We believe this will address your concerns. Please implement the changes and feel free to raise any further issues if needed.
Thank you and have a great day ahead.