https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IRR-POWER-BI/m-p/795981#M4682 <P>Hey!</P><P>&nbsp;</P><P>I need to find a measure that could calculate de IRR beside the XIRR.</P><P>Thank you.</P><P>&nbsp;</P><P>Best regards.</P> Wed, 18 Sep 2019 16:02:27 GMT Anonymous 2019-09-18T16:02:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IRR-POWER-BI/m-p/795981#M4682 <P>Hey!</P><P>&nbsp;</P><P>I need to find a measure that could calculate de IRR beside the XIRR.</P><P>Thank you.</P><P>&nbsp;</P><P>Best regards.</P> Wed, 18 Sep 2019 16:02:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IRR-POWER-BI/m-p/795981#M4682 Anonymous 2019-09-18T16:02:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IRR-POWER-BI/m-p/796424#M4701 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P><P>&nbsp;</P><P>What's your reason for avoiding the XIRR function? I'm aware that it doesn't handle errors well but that can be worked around.</P><P>&nbsp;</P><P>You could create a table of candidate IRR values then iterate over that table to find which one gives the NPV closest to zero (using XNPV if you are happy to use that).</P><P>&nbsp;</P><P>Regards,</P><P>Owen</P> Thu, 19 Sep 2019 02:38:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IRR-POWER-BI/m-p/796424#M4701 OwenAuger 2019-09-19T02:38:44Z