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
Center of Excellence

DOWNLOAD


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
Membership