CUMIPMT DAX Function (Financial)
Returns the cumulative interest paid on a loan between start_period and end_period.
Syntax
CUMIPMT ( <Rate>, <Nper>, <Pv>, <Start_period>, <End_period>, <Type> )
| Parameter | Attributes | Description |
|---|---|---|
| Rate |
The interest rate. |
|
| Nper |
The total number of payment periods. |
|
| Pv |
The present value. |
|
| Start_period |
The first period in the calculation. Payment periods are numbered beginning with 1. |
|
| End_period |
The last period in the calculation. |
|
| Type |
The timing of the payment. |
Return values
Scalar A single decimal value.
Last update: Jul 17, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/cumipmt-function-dax
2018-2025 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies