ISPMT DAX Function (Financial)
Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments.
Syntax
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
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/ispmt-function-dax