Forum Discussion

TarekB's avatar
TarekB
Regular Visitor
2 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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/1447523