DAX Function Guide

The XIRR function calculates in the internal rate of return for series of cash flows that occur at irregular intervals. To calculate the internal rate of return for a series of regular, periodic cash flows, use the IRR function.

• When entering the cash flow values, the value that is dated at the beginning of the investment must be negative.
• The cash flow values can be listed in any chronological order because the corresponding date is provided.
• If you don’t have at least 1 positive and 1 negative cash flow value, the XIRR function will return the #NUM! error.
• If you provide an invalid date in the date parameter, the XIRR function will return #NUM! error.
• Excel tries to recalculate the XIRR until the result is accurate within 0.000001 percent. If after 100 tries Excel has not calculated an accurate value, it will return the #NUM! error.