XIRR Returning Error @ Select Investments

[kent-culpepper]

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.. it is not able to display the IRR values for the other investments that are not an issue, i.e. whole visual just returns "Can't display the visual.".

dates\values @ investment in question

error;

expression;

IRR = XIRR(FILTER(Cash_Flows,Cash_Flows[Transaction]<>0),Cash_Flows[Transaction],Cash_Flows[Entry_Date_Bank])

[Anonymous]

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.