The syntax of the TBILLPRICE function is as follows:
TBILLPRICE(settlement, maturity, discount)
- `settlement`: The settlement date of the T-Bill.
- `maturity`: The maturity date of the T-Bill.
- `discount`: The discount rate of the T-Bill.
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.
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.