YIELDDISC

How to Use the Power BI DAX function YIELDDISC

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)

Upcoming Courses

11-13 November 2024

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)