Hello,I am hoping to figure out how to return an XIRR on each Investment Entity I own. I have tried the simple "IF" EntityID is equal, then XIRR function and get the
Error: There isn't a valid result for the XIRR function for the given values.
I have also tried something I found on the Help site, it's returning a value but I can't scale it across the dataset and the value looks incorrect.
Go to Solution.
Could you post a sample of your data?
The arguments for the XIRR function are:
Your initial formula didn't seem to have a Dates argument.
The Values and Dates arguments are evaluated in the row context of the first Table argument, and can either be column references or other expressions.
The longer IRR expression you posted I believe was from a question a while ago where cashflows that needed their sign reversed under certain conditions, so may or may not apply in your situation.
Proud to be a Datanaut!
Thank you Owen for offering help. Data pasted below.
I looked up an old post of yours and figured it out! Thank you vm!!
Glad you solved it Glancing at your data my main observation is that the PERIOD values would need to be converted to dates.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!