Solved: Problem with XIRR function

TarekB · ‎11-17-2023

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,

Anonymous · ‎11-19-2023

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 Chang

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

View solution in original post

Anonymous · ‎11-19-2023

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 Chang

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

lbendlin · ‎11-19-2023

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-...
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/1447...