COUPDAYBS DAX Function (Financial)
Returns the number of days from the beginning of a coupon period until its settlement date.
Syntax
COUPDAYBS ( <Settlement>, <Maturity>, <Frequency> [, <Basis>] )
| 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. |
|
| 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
Scalar A single integer value.
Last update: Oct 22, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/coupdaybs-function-dax
2018-2025 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies