XIRR Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
Syntax
XIRR(table, values, dates, [guess])
Parameters
table – A table for which the values and dates expressions should be calculated.
values – An expression that returns the cash flow value for each row of the table.
dates – An expression that returns the cash flow date for each row of the table.
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.
Reference Data
https://docs.microsoft.com/en-us/dax/dax-function-reference