Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

change IRR formula

Hi all,

 

Ik have ameasure with the following calculation in it

  XIRR ( CashflowForIRR, [CashflowForIRR], [Date] )
I want to change this formula into: XIRR, if error then 0.
What is the formula i need to use
At this
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous , 

    I am not clear about your requirement, if you want to use a conditional expression, you could try below to see whether it work or not

    Measure = IF(ISERROR(XIRR( T1, [Payment], [Date] ) ), 0,XIRR( T1, [Payment], [Date] ) )

     If this is not waht you want, please correct me and inform me more detailed information.

    Best Regards,
    Zoe Zhi

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

1 Reply

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous , 

    I am not clear about your requirement, if you want to use a conditional expression, you could try below to see whether it work or not

    Measure = IF(ISERROR(XIRR( T1, [Payment], [Date] ) ), 0,XIRR( T1, [Payment], [Date] ) )

     If this is not waht you want, please correct me and inform me more detailed information.

    Best Regards,
    Zoe Zhi

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