Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure XIRR in DAX

Hello all,

I have a problem with the Measure XIRR. The calculation is correct if I only access values, date and category in a table. If I then slice the table over another table with a 1:n connection the following error occurs:

 

MdxScript(Model) (106, 34) Calculation error in measure 'Med DAX'[XIRRF]: The XIRR function couldn't find a solution.

 

Apparently it is not possible for me to slice the table with another table. Only if I activate a value in the slicer for the table of the IRR, a result is displayed again. This is also possible for a multiple selection. Does anyone else know this error and can suggest a solution? Or give further support?

 

Many thanks and best regards
Carsten

No Replies