DAX Statistical - XIRR function

Description

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. DAX XIRR function is new in Excel 2016.

XIRR (<table>, <values>, <dates>, [<guess>])

Sr.No.	Parameter & Description
1	table A table for which the values and dates expressions should be calculated.
2	values An expression that returns the cash flow value for each row of the table.
3	dates An expression that returns the cash flow date for each row of the table.
4	guess Optional. An initial guess for the internal rate of return. If omitted, the default guess of 0.1 is used.

Internal rate of return for the given inputs.

If the calculation fails to return a valid result, an error is returned.

The value is calculated as the rate that satisfies the following function −

$$\sum_{j=1}^N\:\frac{P_{j}}{(1+rate)\frac{d_{j}-d_{1}}{365}}$$

Where $P_{j}$ is the j-th payment $d_{j}$ payment date, and $d_{1}$ is the first payment date.

The series of cash flow values must contain at least one positive number and one negative number.

= XIRR (CashFlows,[AMOUNT],[DATE])

dax_functions_statistical.htm

Get certified by completing the course