ISPMT DAX Function (Financial)
Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments.
The interest rate for the investment.
The period for which you want to find the interest, and must be between 1 and Nper.
The total number of payment periods for the investment.
The present value of the investment. For a loan, Pv is the loan amount.
Last update: Jun 6, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/ispmt-function-dax