Forum Discussion
PowerBI Generating XIRR error when excel can calculate
Here is a synthetic case where I am seeing the problem. In PowerBI i am getting Error (which i set as 999,) while in excel i can get 4%
Thank you!
Anonymous , I am getting this 4%
Try a measure like XIRR = XIRR(Data, Data[Flow], Data[Date],.999)
2 Replies
- amitchandak
Super User
Anonymous , I am getting this 4%
Try a measure like XIRR = XIRR(Data, Data[Flow], Data[Date],.999)