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.

Anonymous's avatar
Anonymous
Not applicable
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.