Forum Discussion
Formula required for XIRR calculation
I have the following cash flow details for our investor. Cashflow_date Investor_Name Cashflow_Amt 3/11/2011 A -1823000 10/19/2015 A -700000 4/3/2018 A 0 6/7/2018 A 374...
Hi Vigneshkris,
Based on my test, XIRR function returns the same result in Excel and Power BI based on above sample data.
In your scenario, please make sure the dataset loaded into desktop is exactly same as that in Excel without missing any row. Please check whether you have applied any filter to dataset in desktop.
Regards,
Yuliana Gu