https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-Pivot/m-p/2909674#M95056 <P>Well, because some functions have not been implemented by M$ in Excel. The short answer is.</P> Wed, 16 Nov 2022 13:51:37 GMT daXtreme 2022-11-16T13:51:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-Pivot/m-p/2909454#M95037 <P>I realize that this is an excel question, but thought this would be a good place to ask regardless.<BR />Why isnt functions like IPMT available in the data model /power pivot in Excel?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Only in the workbook</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Regards,</P><P>Anders</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 16 Nov 2022 12:22:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-Pivot/m-p/2909454#M95037 AndersASorensen 2022-11-16T12:22:35Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-Pivot/m-p/2909674#M95056 <P>Well, because some functions have not been implemented by M$ in Excel. The short answer is.</P> Wed, 16 Nov 2022 13:51:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-Pivot/m-p/2909674#M95056 daXtreme 2022-11-16T13:51:37Z