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...
v-qiuyu-msft
Community Support
Community SupportHi Anonymous ,
XIRR doesn't guarantee to find a solution. This is true for both Excel and Power BI. That being said, Power BI uses a different algorithm than Excel, so given a particular sequence of data points, one of the products may find a solution but the other doesn't. This is by design, not a product defect.
Best Regards,
Qiuyun Yu