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.
Linked below is an excel with the expected outcome if the following accounts were selected for the Aggregate XIRR:
A458
B672
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.