ISPMT DAX Function (Financial)
Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments.
Syntax
ISPMT ( <Rate>, <Per>, <Nper>, <Pv> )
| Parameter | Attributes | Description |
|---|---|---|
| Rate |
The interest rate for the investment. |
|
| Per |
The period for which you want to find the interest, and must be between 1 and Nper. |
|
| Nper |
The total number of payment periods for the investment. |
|
| Pv |
The present value of the investment. For a loan, Pv is the loan amount. |
Return values
Scalar A single decimal value.
Last update: Oct 22, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/ispmt-function-dax
2018-2025 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies