Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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
Any help on this please ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
106 | |
86 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |