Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
The table containing the rows for which the Values and Dates expressions will be evaluated.
An expression to be evaluated for each row of the table, which will yield a series of cash flows.
An expression to be evaluated for each row of the table, which will yield a schedule of payment dates.
Optional. A number that you guess is close to the result of XIRR.
Internal rate of return for the given inputs. If the calculation fails to return a valid result, an error is returned.
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/xirr-function-dax