Anonymous's avatar
Anonymous
Not applicable
7 years ago
Status:
New

XIRR DAX - Bug

Hi Team,   It seems like a PowerBI bug to me.    I'm trying to calculate XIRR using DAX with a certain dataset which is provided below. It works like a charm in excel but returns an error "XIRR f...
Report Server
Reports
dancarr22's avatar
dancarr22
Icon for Helper V rankHelper V
3 years ago

I also need a fix for this.  We get different values from XIRR in PBI based on the 'guess' value we enter.  The results swing wildly based on very minor variations in guess.  i.e. If we pass in a guess of .1 it returns a correct value of 11.45%.  If we pass in a guess of .08 it returns an incorrect value of 498%.  Would really help to get this fixed.  It is unusable and unreliable in the current state - especialy when Excel and other calculators work.  

Completed Ideas