DURATION DAX Function (Financial)
Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price’s response to changes in yield.
Syntax
Parameter | Attributes | Description |
---|---|---|
Settlement |
The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. |
|
Maturity |
The security’s maturity date. The maturity date is the date when the security expires. |
|
Coupon |
The security’s annual coupon rate. |
|
Yld |
The security’s annual yield. |
|
Frequency |
The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4. |
|
Basis | Optional |
The type of day count basis to use. |
Return values
Last update: Oct 3, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/duration-function-dax