Syntax
IRR is not available as a DAX function yet. In this video I show you how to calculate it manually.
Tutorial with example
In todays video I will show you how to calculate XIRR (straight forward) but also how to calculate IRR (missing function in DAX)
Download example files:
Download the pbix and excel file here.
Remarks
The value is calculated as the rate that satisfies the following function:
The series of cash flow values must contain at least one positive number and one negative number.
Was this helpful?
Leave a Reply