# YIELDDISC

## Y ## Understanding the YIELDDISC Function

The YIELDDISC function calculates the yield of a security that has a discount at maturity. It takes four arguments: settlement, maturity, pr, and redemption. The settlement argument is the date on which the security is purchased. The maturity argument is the date on which the security matures. The pr argument is the price per \$100 face value of the security. The redemption argument is the redemption value per \$100 face value of the security at maturity.

The function returns the yield of the security as a decimal number. The yield is the annual interest rate that the security would have if it were sold at the current market price.

## Using the YIELDDISC Function in Power BI

To use the YIELDDISC function in Power BI, you must first create a table or import a table that contains the settlement, maturity, pr, and redemption values for the securities you want to analyze.

Once you have the table, you can create a measure that uses the YIELDDISC function to calculate the yield for each security. To create the measure, follow these steps:

1. Open Power BI and go to the “Data” tab.

2. Select the table that contains the settlement, maturity, pr, and redemption values for the securities you want to analyze.

3. Click on the “New Measure” button in the “Modeling” tab.

4. In the formula bar, enter the following formula:

YieldDISC = YIELDDISC(Table[Settlement], Table[Maturity], Table[Pr], Table[Redemption])

``` 5. Replace "Table" with the name of your table. 6. Click "Enter" to create the measure. Once you have created the measure, you can use it in visualizations and reports to analyze the yield of your securities. Examples of Using the YIELDDISC Function To better understand how to use the YIELDDISC function in Power BI, let's look at a few examples: Example 1: Calculating Yield for a Single Security Suppose you have a security with the following details: - Settlement date: 1/1/2020 - Maturity date: 12/31/2020 - Price per \$100 face value: \$98 - Redemption value per \$100 face value: \$100 To calculate the yield of this security using the YIELDDISC function, you would enter the following formula in the formula bar: ```

YieldDISC = YIELDDISC(1/1/2020, 12/31/2020, 98, 100)

``` The function would return the yield of the security as a decimal number. Example 2: Calculating Yield for Multiple Securities Suppose you have a table that contains the settlement, maturity, pr, and redemption values for multiple securities. To calculate the yield for each security using the YIELDDISC function, you would create a measure using the formula we discussed earlier. You could then use the measure in a table visualization to display the yield for each security. The YIELDDISC function is a powerful tool for calculating the yield of securities that have a discount at maturity. By following the steps we discussed in this article, you can easily use the function in Power BI to analyze your securities and make informed investment decisions. Power BI DAX Training Courses by G Com Solutions (0800 998 9248) Power BI DAX Intensive Training Course £1,050.00 – £26,550.00 Select optionsContinue Loading Done Power BI DAX Introduction £395.00 – £9,750.00 Select optionsContinue Loading Done Power BI DAX Intermediate £395.00 – £9,750.00 Select optionsContinue Loading Done Power BI DAX Advanced £395.00 – £9,750.00 Select optionsContinue Loading Done Upcoming Courses 6-8 Jun 23 (London or Online)8-10 Aug 23 (London or Online)24-26 Oct 23 (London or Online) Contact Us Subject Your Name (required) Company/Organisation Email (required) Telephone Training Course(s) Power BI Intensive TrainingPower BI introduction Power BI IntermediatePower BI AdvancedDAXPower Query MPower BI CertificationPower BI AdministrationPower PlatformPower AutomatePower AppsOTHER Your Message Upload Example Document(s) (Zip multiple files) ```
``` ```
``` ```
``` ```
``` ```
``` ```