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