T.INV Function (DAX)

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

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

T.INV Formula Syntax

T.INV(
     Probability,Deg_freedom
)

How do you use the T.INV function?

This function will calculate the left-tailed student’s t-distribution. The student’s t-distribution is a continuous probability distribution that is frequently used in testing hypotheses on small sample data sets.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
Nulls/Blanks DAX Measure

Considerations when using the T.INV function

  • If either argument is nonnumeric, T.INV returns the #VALUE! error value.
  • If probability <= 0 or if probability > 1, T.INV returns the #NUM! error value.
  • If deg_freedom is not an integer, it is truncated.
  • If deg_freedom < 1, T.INV returns the #NUM! error value.

Related Video Tutorials

Formula examples using the T.INV function

EVALUATE { T.INV(0.75, 2) }

=T.INV(0.75,2)

=T.INV( 0.25, 10 )

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.