XNPV

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.