Forum Discussion

austinsense's avatar
austinsense
Icon for Impactful Individual rankImpactful Individual
10 years ago

Solution to XIRR with Terminal Values

I want to share this with the community because it should be helpful to lots of finance people working with DAX.  Power BI and Excel 2016 now have an XIRR function which is great but it's not designe...
Tips and Tricks
jasonjs's avatar
jasonjs
Regular Visitor
8 years ago

Hi mjfigg,

 

I am looking for exacly what you have described. I've copied your formulas bet get a number of errors including "Earlier/Earliest refers to an earlier row context which doesn't exist". Any chance you could proivide a copy/screenshot of your Source table and the Power BI File?

Thanks,

 

JS

austinsense's avatar
austinsense
Icon for Impactful Individual rankImpactful Individual
8 years ago

This formula needs some re-work. I've been meaning to update it. Let me give it some work.