Archive by Author

TODAY Function (DAX)

How does the TODAY function (DAX) work? The TODAY function (DAX) returns the current date. TODAY Formula Syntax TODAY (     ) How do you use the TODAY function? The TODAY function is useful when yo...

TIMEVALUE Function (DAX)

How does the TIMEVALUE function (DAX) work? The TIMEVALUE function (DAX) converts a time in text format to a time in datetime format. TIMEVALUE Formula Syntax TIMEVALUE (     time_text) How do you ...

TIME Function (DAX)

How does the TIME function (DAX) work? The TIME function (DAX) returns a decimal number between 0 and 0.999988426 given an hour, minute and second value. A result of 0 represents 12:00:00 AM and a res...

TANH Function (DAX)

How does the TANH function (DAX) work? The TANH function (DAX) returns the hyperbolic tangent of a number. TANH Formula Syntax TANH(     number) How do you use the TANH function? This function will...

UPPER Function (DAX)

How does the UPPER function (DAX) work? UPPER function (DAX) converts a text string to all uppercase letters. UPPER Formula Syntax How do you use the UPPER function? It converts the string in the colu...

TAN Function (DAX)

How does the TAN function (DAX) work? The TAN function (DAX) returns the tangent of the given angle. TAN Formula Syntax TAN(     number) How do you use the TAN function? The TAN function expects ra...

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 T.INV.2T(     Probabilit...

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 y...

T.DIST.RT Function (DAX)

How does the T.DIST.RT function (DAX) work? The T.DIST.RT function (DAX) returns the right-tailed Student’s t-distribution. T.DIST.RT Formula Syntax T.DIST.RT(     X,Deg_freedom) How do you use t...

UNION Function (DAX)

How does the UNION function (DAX) work? UNION function (DAX) is where a union (join) table is formed from a pair of tables. UNION Formula Syntax How do you use the UNION function? The two tables must ...