Forum Discussion
juliliscarmo
Helper I
7 years agoMeasure to calculate IRR
Hi all,
I'm trying to find a way to calculate the IRR, not the XIRR, just IRR.
Thank you
Juli
7 Replies
- LivioLanzo
Solution Sage
There is no IRR built in function, but you can calculate it like it with a workaround
IRR % = XIRR ( ADDCOLUMNS ( Data, "Date365", CALCULATE ( COUNTROWS ( Data ), Data[Date] < EARLIER ( Data[Date] ), ALL ( Data ) ) * 365 + CALCULATE ( MIN ( Data[Date] ), ALL ( Data ) ) ), [Amount], [Date365] )The above measure returns 8.41%
- juliliscarmo
Helper I
Hi LivioLanzo
Unfortunately, this formula is not working well when I have blank cells. Do you have any idea why?
I really appreciate your help, please see below my table format.Client Category Date Value Values Last 1 year 1 A 1/1/2017 300.00 -300.00 1 B 1/1/2017 200.00 1 B 1/2/2017 150.00 150.00 1 C 4/2/2017 250.00 250.00 1 C 4/2/2017 400.00 400.00 1 A 8/2/2017 230.00 230.00 1 B 8/7/2017 300.00 2 B 8/7/2016 300.00 2 A 9/7/2016 500.00 -500.00 2 B 9/17/2016 300.00 300.00 2 C 9/7/2017 150.00 150.00 2 A 9/7/2017 200.00 200.00 Thank you
Juli
- LivioLanzo
Solution Sage
- AnonymousNot applicable
Hello Team, IS there any updates for this XIRR function grouping by category. Eg: I have to calculate XIRR value for different projects which was in same table.
Kindly help on this case Thank you M Logendran