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 |
An expression to be evaluated for each row of the table, which will yield a series of cash flows. |
|
Dates Row Context |
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: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/xirr-function-dax