Forum Discussion

kent-culpepper's avatar
kent-culpepper
Frequent Visitor
2 years ago

XIRR Returning Error @ Select Investments

I have XIRR working in most cases-- but for whatever reason some investments, like the below, are returning an error. And I'm finding that with a table visual that exposes the investment in issue.. i...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi kent-culpepper ,

Please pay attention!

The series of cash flow values must contain at least one positive number and one negative number.

Avoid using ISERROR or IFERROR functions to capture an error returned by XIRR. If some inputs to the function may result in a no solution error, providing an alternateResult parameter is the most reliable and highest performing way to handle the error.

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

XIRR function (DAX) - DAX | Microsoft Learn

Solved: XIRR function cannot find solution - Microsoft Fabric Community

Solved: The XIRR function is not working - Microsoft Fabric Community

Solved: XIRR Calculation Error - Microsoft Fabric Community

 

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.