Forum Discussion
Problem with XIRR function
Hello , I am struggling with XIRR function I would be thankful if can someone helps me solve it.
This is the table I created below to be able to calculate the IRR. The result I am getting is not correct.
This is my measure :
Thank you in advance.
Regards,
Hi TarekB ,
It may be that your databook does not support the use of the XIRR function, you can try to remove the last two optional parameters, the result may report an error. At least one positive or negative number is required, exactly you can refer to:XIRR function (DAX) - DAX | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi TarekB ,
It may be that your databook does not support the use of the XIRR function, you can try to remove the last two optional parameters, the result may report an error. At least one positive or negative number is required, exactly you can refer to:XIRR function (DAX) - DAX | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
