PDURATION DAX Function (Financial)
Returns the number of periods required by an investment to reach a specified value.
Syntax
PDURATION ( <Rate>, <Pv>, <Fv> )
| Parameter | Attributes | Description |
|---|---|---|
| Rate |
The interest rate per period. |
|
| Pv |
The present value of the investment. |
|
| Fv |
The desired future value of the investment. |
Return values
Scalar A single decimal value.
Last update: Nov 23, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/pduration-function-dax
2018-2025 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies