Syntax
XNPV(<table>, <values>, <dates>, <rate>)
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?
Let us know your thoughts...