TBILLPRICE

TBILLPRICE

How to Use the Power BI DAX function TBILLPRICE

Syntax

The syntax of the TBILLPRICE function is as follows:


TBILLPRICE(settlement, maturity, discount)


Where:

- `settlement`: The settlement date of the T-Bill.

- `maturity`: The maturity date of the T-Bill.

- `discount`: The discount rate of the T-Bill.

Arguments

The arguments of the TBILLPRICE function are as follows:

- `settlement`: This is a required argument that represents the settlement date of the T-Bill. It must be a valid date in the format of "mm/dd/yyyy".

- `maturity`: This is a required argument that represents the maturity date of the T-Bill. It must be a valid date in the format of "mm/dd/yyyy".

- `discount`: This is a required argument that represents the discount rate of the T-Bill.

Example

Suppose we want to calculate the price of a T-Bill with a settlement date of January 1, 2021, a maturity date of June 30, 2021, and a discount rate of 4%. The formula to do so would be as follows:


TBILLPRICE(“01/01/2021”, “06/30/2021”, 0.04)


This would give us a result of 98.060909, which means that the T-Bill can be purchased for $98.06.

Using TBILLPRICE in Power BI DAX

To use the TBILLPRICE function in Power BI DAX, we need to follow the steps below:

1. Open Power BI Desktop and create a new report.

2. Go to the "Modeling" tab and click on "New Measure".

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


TBILLPRICE([Settlement Date], [Maturity Date], [Discount Rate])


4. Replace the placeholders with the names of the columns in your data table that contain the settlement date, maturity date, and discount rate data.

5. Press "Enter" to create the measure.

Now, we can use this measure in our report to calculate the T-Bill price based on the data in our table.

The TBILLPRICE function is a powerful financial function in Power BI DAX that can be used to calculate the price of a Treasury Bill. By using this function, we can easily determine the price at which a T-Bill can be sold or purchased in the market. We hope this article has helped you understand how to use the TBILLPRICE function in Power BI DAX.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us

Subject

Your Name (required)

Company/Organisation

Email (required)

Telephone

Training Course(s)

Your Message

Upload Example Document(s) (Zip multiple files)

Copyright, G Com Solutions Ltd, 2024.
Tower Bridge Business Centre, 46-48 East Smithfield, London E1W 1AW
0800 998 9248   |   9:00 a.m. till 5:30 p.m.

Connect With Me: