Formula required for XIRR calculation

[Vigneshkris]

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	3744301.39
5/25/2015	B	-2805000
8/30/2015	B	305534.35
10/12/2015	B	-305535
4/3/2018	B	0
6/7/2018	B	3320473.84
However when I use the XIRR formula  I am getting the calculation as shown below which doesent look correct . Can you please help in sorting out the issue.
Investor Name	Column
A	-2.57
B	-2.57
Total	-5.14
We created a new XIRR column with the formula as shown below
IRR_Calc= XIRR(IRR,IRR[Cashflow_Amt],IRR[Cashflow_date])
However when I try to run this in excel I am getting the value populated properly as 6.77 %
Can you please let us know what should be the formula for the column IRR_Calc

[v-yulgu-msft]

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

[Vigneshkris]

Any help on this please ?