How to Use the Power BI DAX function TBILLEQ

To use the TBILLEQ function in Power BI, you need to provide three arguments:

– Settlement: The date on which the T-bill was purchased.

– Maturity: The date on which the T-bill will mature.

– Discount rate: The discount rate to be used for calculating the yield.

Here is a step-by-step guide on how to use the TBILLEQ function in Power BI:

Step 1: Create a New Measure

To begin, you need to create a new measure in Power BI. You can do this by selecting the “New Measure” option from the “Modeling” tab in the ribbon.

Step 2: Enter the TBILLEQ Function

Next, you need to enter the TBILLEQ function into the formula bar. The syntax for the function is as follows:

TBILLEQ(settlement, maturity, discount)

Replace "settlement", "maturity", and "discount" with the appropriate values.

Step 3: Enter the Arguments

In the parentheses, you need to enter the arguments for the function. The first argument is the settlement date, which is the date on which the T-bill was purchased. The second argument is the maturity date, which is the date on which the T-bill will mature. The third argument is the discount rate, which is the rate used to calculate the yield.

For example, if the settlement date is January 1, 2021, the maturity date is June 30, 2021, and the discount rate is 0.05, the TBILLEQ function would look like this:

TBILLEQ(“1/1/2021”, “6/30/2021”, 0.05)

Step 4: Check the Result

Once you have entered the function and arguments, click "Enter" to calculate the yield. The result should be displayed in the measure you created earlier. You can format the measure to display the result as a percentage.

The TBILLEQ function in Power BI is a useful tool for calculating the yield on a US Treasury bill. By following the steps outlined in this guide, you can easily use this function in your Power BI reports and dashboards.

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

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


    Your Name (required)


    Email (required)


    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)