XIRR DAX Function (Financial)
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
|
Table Iterator |
The table containing the rows for which the Values and Dates expressions will be evaluated. |
|
|
Values Row Context By Expression |
An expression to be evaluated for each row of the table, which will yield a series of cash flows. |
|
|
Dates Row Context By Expression |
An expression to be evaluated for each row of the table, which will yield a schedule of payment dates. |
|
| Guess | Optional |
Optional. A number that you guess is close to the result of XIRR. |
| AlternateResult | Optional |
Optional. The alternate result to return when XIRR cannot find a solution. |
Return values
Internal rate of return for the given inputs. If the calculation fails to return a valid result, an error is returned.
Related functions
Other related functions are:
Last update: Oct 22, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/xirr-function-dax