There is a DAX XIRR function which works great. However, when considering equal time periods such as monthly or yearly, the XIRR results are very close but not exact to what we would get if we were u...
This is still relevant. Being able to reconcile calculations done in Excel using NPV and IRR would be helpful. In our case, being able to reconcile prices calculated in Excel and Power BI is important, and the 365 day calendars in XNPV and XIRR throw off the numbers in meaningful ways.
