A
C
- CALCULATE
- CALCULATETABLE
- CALENDAR
- CALENDARAUTO
- CEILING
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- COALESCE
- COLUMNSTATISTICS
- COMBIN
- COMBINA
- COMBINEVALUES
- CONCATENATE
- CONCATENATEX
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONTAINS
- CONTAINSROW
- CONTAINSSTRING
- CONTAINSSTRINGEXACT
- CONVERT
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CROSSFILTER
- CROSSJOIN
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENTGROUP
- CUSTOMDATA
D
E
I
N
O
P
R
S
- SAMEPERIODLASTYEAR
- SAMPLE
- SEARCH
- SECOND
- SELECTCOLUMNS
- SELECTEDMEASURE
- SELECTEDMEASUREFORMATSTRING
- SELECTEDMEASURENAME
- SELECTEDVALUE
- SIGN
- SIN
- SINH
- SLN
- SQRT
- SQRTPI
- STARTOFMONTH
- STARTOFQUARTER
- STARTOFYEAR
- STDEVX.P
- STDEVX.S
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUBSTITUTEWITHINDEX
- SUM
- SUMMARIZE
- SUMMARIZECOLUMNS
- SUMX
- SWITCH
- SYD
T
U
One of the functions available in DAX is T.DIST.2T. This function calculates the two-tailed probability of the Student’s t-distribution. In this article, we will explore how to use the T.DIST.2T function in Power BI.
Syntax of T.DIST.2T Function
The syntax of the T.DIST.2T function is as follows:
T.DIST.2T(x, degrees_freedom)
The `x` parameter is the numeric value at which to evaluate the distribution. The `degrees_freedom` parameter is the number of degrees of freedom.
Example Calculation
Suppose we have a dataset that contains the following information:
| Student | Test Score |
|---------|------------|
| Alice | 85 |
| Bob | 72 |
| Charlie | 91 |
| Dave | 78 |
| Ellen | 89 |
We want to calculate the two-tailed probability of the t-distribution for a test score of 80 with 4 degrees of freedom using the T.DIST.2T function.
The calculation for this would be:
T.DIST.2T(ABS((80 – AVERAGE(Test Score)) / (STDEV.P(Test Score) / SQRT(COUNT(Test Score)))), 4)
The `ABS` function returns the absolute value of the difference between the test score and the average test score. The `AVERAGE` function calculates the average test score. The `STDEV.P` function calculates the standard deviation of the test scores. The `SQRT` function calculates the square root of the number of test scores.
Using T.DIST.2T Function in Power BI
To use the T.DIST.2T function in Power BI, follow these steps:
1. Open Power BI Desktop and create a new report.
2. Import your data into Power BI.
3. Go to the "Modeling" tab.
4. Click on "New Measure".
5. In the formula bar, type the syntax for the T.DIST.2T function, replacing the `x` and `degrees_freedom` parameters with your own values.
6. Press "Enter" to create the measure.
Your T.DIST.2T function is now ready to be used in your report.
The T.DIST.2T function is a valuable tool for calculating the two-tailed probability of the Student's t-distribution in Power BI. By following the steps outlined in this article, you can easily use this function in your own reports and gain valuable insights into your data.