Forum Discussion

dmbd1904's avatar
dmbd1904
Helper III
6 years ago
Solved

XIRR DAX Help

Hi I've been trying for hours to make this work without success. Does anybody know if it's possible to use a measure as the cashflow part of a XIRR function?   Measure 2 = VAR CALC2= (-CALCULAT...
Need Help
  • dmbd1904's avatar
    dmbd1904
    6 years ago

    Hi v-xicai, the issue was where the cashflow calculations returned a blank value. To overcome this I used an IfError statement within the XIRR calc. Thanks for your replies

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi   dmbd1904 ,

 

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

  • dmbd1904's avatar
    dmbd1904
    Helper III
    6 years ago

    Hi v-xicai, the issue was where the cashflow calculations returned a blank value. To overcome this I used an IfError statement within the XIRR calc. Thanks for your replies