# 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.

## Syntax

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


## Parameters

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.

## Return Value

Internal rate of return for the given inputs.

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

## Remarks

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.

## Example

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

dax_functions_statistical.htm