Syntax
XIRR(<table>, <values>, <dates>, [guess])
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 following summation:
The series of cash flow values must contain at least one positive number and one negative number.
Was this helpful?
Leave a Reply