Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
GAPER
Post Patron
Post Patron

XIRR aggregration on some groups but not other

Here is my table.

 

You see the first groupping of 11.9% is a right IRR (using all the cash flows from the 2 projects underthese 2 groups)

 

however when it comes to the second one, it's not giving me the right number, despite each individual project irr is correctly calculated. 

GAPER_0-1705982019879.png

Anyone knows how to fix this? Thanks

 

 

I have created a dummmy cashflow to replicate the above

 

GAPER_0-1705996581164.png

 

IndustryProjectCF_DATE_DUMMYTotal Value
1a1/1/2004-50
1a7/1/2004135
2b12/18/2007-10
2b12/31/2007-380
2b3/4/2008-10
2b8/31/2008-240
2b11/30/2008-5
2b12/21/201015
2b4/4/20115
2b4/30/201110
2b7/14/2011140
2b1/31/2012-115
2b2/28/2012115
2b3/31/2012-95
2b4/30/2012115
2b5/14/201210
2b8/31/20125
2b10/5/2012-15
2b2/28/2013-5
2b3/31/201380
2b4/10/201380
2b5/31/20135
2b7/31/2013-15
2b1/31/2014-90
2b6/30/20145
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
2f3/16/2015-10
2f7/22/2015-5
2f8/10/2015-5
2f3/30/201740
2f5/19/201740
2f5/31/2017-10
2f8/31/2017100
2f9/28/2017-175
2f10/31/201725
2f11/13/2017-25
2f4/9/201850
2f4/10/20185
    
    
    
    
    
    
    
1l7/28/2017-10
1l8/3/201812
1m12/18/2017-10
1m8/3/201810
1m8/9/20181

 

1 ACCEPTED SOLUTION

Updated King. Please help

 

View solution in original post

2 REPLIES 2
Fowmy
Super User
Super User

@GAPER 

You need to share some sample/dummy data and the measure you have used.
Better, if you can share a PBIX file 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Updated King. Please help

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.