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...
Thanks Yu for your response.
I've already figured out the problem. And yes you are partially correct with your approach to calculate
1. PBI doesn't work if the net value is zero on the first date.
2. PBI still works with multiple values per date.
I still don't understand why this same dataset works in excel and not in Power BI. One would expect the exact same functionality when replicating excel to Power BI.
I feel this is definetely a bug in PBI which is not handled.
Cheers,
Hari T