A
C
- CALCULATE
- CALCULATETABLE
- CALENDAR
- CALENDARAUTO
- CEILING
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- COALESCE
- COLUMNSTATISTICS
- COMBIN
- COMBINA
- COMBINEVALUES
- CONCATENATE
- CONCATENATEX
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONTAINS
- CONTAINSROW
- CONTAINSSTRING
- CONTAINSSTRINGEXACT
- CONVERT
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CROSSFILTER
- CROSSJOIN
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENTGROUP
- CUSTOMDATA
D
E
I
N
O
P
R
S
- SAMEPERIODLASTYEAR
- SAMPLE
- SEARCH
- SECOND
- SELECTCOLUMNS
- SELECTEDMEASURE
- SELECTEDMEASUREFORMATSTRING
- SELECTEDMEASURENAME
- SELECTEDVALUE
- SIGN
- SIN
- SINH
- SLN
- SQRT
- SQRTPI
- STARTOFMONTH
- STARTOFQUARTER
- STARTOFYEAR
- STDEVX.P
- STDEVX.S
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUBSTITUTEWITHINDEX
- SUM
- SUMMARIZE
- SUMMARIZECOLUMNS
- SUMX
- SWITCH
- SYD
T
U
What is the COUPNUM Function?
The COUPNUM function in Power BI is used to calculate the number of coupons that are due between the settlement date and the maturity date of a security. It takes four arguments:
1. Settlement: The settlement date of the security.
2. Maturity: The maturity date of the security.
3. Frequency: The number of coupon payments per year.
4. Basis: The day count basis to use.
The COUPNUM function returns the number of coupons due between the settlement and maturity dates.
Syntax of the COUPNUM Function
The syntax of the COUPNUM function is as follows:
COUPNUM(settlement, maturity, frequency, [basis])
The arguments are defined as follows:
1. Settlement: The date that the security is sold or settled.
2. Maturity: The date that the security matures.
3. Frequency: The number of coupon payments per year. This can be either 1, 2, or 4.
4. Basis: (Optional) The day count basis to use. This can be either 0, 1, 2, 3, or 4.
How to Use the COUPNUM Function in Power BI
To use the COUPNUM function in Power BI, follow these steps:
1. Open Power BI and create a new report or open an existing report.
2. Click on the 'New Measure' button in the 'Home' tab of the ribbon.
3. In the 'Formula Bar', type the following formula:
COUPNUM(settlement, maturity, frequency, [basis])
4. Replace the arguments with the appropriate values for your data.
5. Press 'Enter' to create the measure.
The measure will now be available to use in your report.
Example of Using the COUPNUM Function in Power BI
Let's assume we have the following data:
- Settlement date: 01/01/2021
- Maturity date: 01/01/2025
- Coupon frequency: 2
- Day count basis: 0
To calculate the number of coupons due between the settlement and maturity dates, we can use the following formula:
COUPNUM(DATE(2021,1,1),DATE(2025,1,1),2,0)
This will return the value 8, which represents the number of coupons due between the settlement and maturity dates.
The COUPNUM function is a powerful tool that can be used to calculate the number of coupons within a given period. By following the steps outlined in this article, you can easily use the COUPNUM function in Power BI to analyze and report on financial data.