T.INV.2t Function (DAX)

How does the T.INV.2t function (DAX) work?

The T.INV.2t function (DAX) returns the two-tailed inverse of the Student’s t-distribution.

T.INV.2t Formula Syntax


How do you use the T.INV.2t function?

This function will calculate the two-tailed Student’s T-Distribution. The Student’s T-Distribution is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

Considerations when using the T.INV.2t function

  • If either argument is nonnumeric, T.INV.2T returns the #VALUE! error value.
  • If probability <= 0 or if probability > 1, T.INV.2T returns the #NUM! error value.
  • If deg_freedom is not an integer, it is truncated.
  • If deg_freedom < 1, T.INV.2T returns the #NUM! error value.
  • T.INV.2T returns that value t, such that P(|X| > t) = probability where X is a random variable that follows the t-distribution and P(|X| > t) = P(X < -t or X > t).
  • A one-tailed t-value can be returned by replacing probability with 2*probability. For a probability of 0.05 and degrees of freedom of 10, the two-tailed value is calculated with T.INV.2T(0.05,10), which returns 2.28139. The one-tailed value for the same probability and degrees of freedom can be calculated with T.INV.2T(2*0.05,10), which returns 1.812462.Given a value for probability, T.INV.2T seeks that value x such that T.DIST.2T(x, deg_freedom, 2) = probability. Thus, precision of T.INV.2T depends on precision of T.DIST.2T.

Related Video Tutorials

Formula examples using the T.INV.2t function

EVALUATE { T.INV.2T(0.546449, 60) }

=T.INV.2T( 0.25, 10 )

=T.INV.2T( 0.5, 10 )

Related DAX Functions

Related Course Modules



Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide