Power BI – DAX Trigonometric Functions

Microsoft Power BI uses the scripting language Data Analysis Expressions (DAX) to create calculated columns, measurements, and custom tables. It offers a number of useful functions that help create formulas and expressions that can be applied to a number of data analysis issues. You can develop reliable and high-performance data models in Power BI by having a fundamental understanding of when and how to use the DAX functions. Working with DAX functions will considerably increase your data evaluation efficiency and competence because you won’t have to worry about the compatibility concerns and limitations that come with ordinary pivot tables.

Dataset used:  Sheet1

DAX Trigonometric Functions

The Data Analysis Expression (DAX) includes many functions that return a table rather than a value. The table isn’t displayed but is used to provide input to other functions. Trigonometric functions return a value. whereas, Measures are used in some of the most common data analyses. Execution of the query creates a measure in the field.

New Measure

The trigonometric and mathematical functions in Excel are quite similar to those in Data Analysis Expressions (DAX). The DAX Trigonometric functions are listed below. The angle should be specified in radians as an argument, if it is in degrees, multiply it by π/180° or use the RADIANS function to convert it to radians. Multiply by 180°/π to get the answer in degrees.

DAX sin(θ) Trigonometric Function

Returns the sine of the specified angle.

Syntax:

SIN(number)

Example:

sine of 45° in radians.

Formula: sin = SIN(RADIANS(45))

Output:

sin

DAX cos(θ) Trigonometric Function

The Power BI DAX COS function returns the cosine value of the angle.

Syntax of DAX cos

COS(expression)

Example:

cosine of 60° in radians.

Formula: cos = COS(RADIANS(60))

Output:

cos

DAX sinh(θ) Trigonometric Function

Returns a number’s hyperbolic sine.

Syntax of DAX sin

SINH(number)

Example:

Hyperbolic sine of 13 in radians.

Formula: sinh = SINH(13)

Output:

sin h

DAX cosh(θ) Trigonometric Function

Returns the hyperbolic cosine of any real number equal to or greater than 1.

Syntax of DAX cosh

COSH(number)

Example: 

The hyperbolic cosine of 12 in radians.

Formula: cosh = COSH(12)

Output:

cos h

DAX tan(θ) Trigonometric Function

Returns the angle’s tangent.

Syntax DAX tan

TAN(number)

Example:

tangent of -3 in radians.

Formula: tan = TAN(-3)

Output:

tan

DAX tanh(θ) Trigonometric Function

The hyperbolic tangent of a number is returned by it.

Syntax of DAX tanh

TANH(number)

Example:

The hyperbolic tangent of 23 in radians.

Formula: tanh = TANH(23)

Output:

tan h

DAX cot(θ) Trigonometric Function

The function returns the cotangent of a real angle with a radian value.

Syntax of DAX cot 

COT(number)

Example:

The cotangent of 25 in radians.

Formula: cot = COT(25)

Output:

cot

DAX coth(θ) Trigonometric Function

The hyperbolic cotangent of a hyperbolic angle whose absolute value must be greater than 1, is returned by the function.

Syntax DAX coth 

COTH(number)

Example:

The hyperbolic cotangent of 37 in radians.

Formula: coth = COTH(37)

Output:

cot h

DAX asin(θ) Trigonometric Function

A number’s arcsine, or inverse sine, is returned by the ASIN() function. The angle whose sine is number is called the arcsine. The returned angle is between -pi/2 and pi/2 in radians. The number in radian must be from -1 to 1.

Syntax of DAX asin

ASIN(number)

Example:

Inverse sine of 0.8 in radians.

Formula: asin = ASIN(0.8)

Output:

asin

DAX asinh(θ) Trigonometric Function

The function ASINH(number) returns the real number’s inverse hyperbolic sine. As ASINH(SINH(number)) equals number, the value whose hyperbolic sine is number is called the inverse hyperbolic sine.

Syntax of DAX asinh

ASINH(number)

Example:

inverse hyperbolic sine of 55 in radians.

Formula: asinh = ASINH(55)

Output:

asinh

DAX acos(θ) Trigonometric Function

The function ACOS() returns the real number’s arccosine, or inverse cosine. The angle whose cosine is a number is called an arccosine. The returning angle is specified from 0 to pi in radians. The number in radian must be from -1 to 1.

Syntax: 

ACOS(number)

Example:

arccosine of -0.5 in radians.

Formula: acos = ACOS(-0.5)

Output:

acos

DAX acosh(θ) Trigonometric Function

Returns a real number’s inverse hyperbolic cosine. It must be greater than or equal to one. ACOSH(COSH(number)) corresponds to a  number because the inverse hyperbolic cosine is the value whose hyperbolic cosine is a number.

Syntax: 

ACOSH(number)

Example:

inverse hyperbolic of 60 cosine in radians.

Formula: acosh = ACOSH(60)

Output:

acosh

DAX atan(θ) Trigonometric Function

Provides a number’s arctangent, or inverse tangent. The angle whose tangent is a number is an arctangent. The returned angle is between -π/2 and π/2 in radians.

Syntax of DAX atan

ATAN(number)

Example:

inverse tangent of 48 in radians.

Formula: atan = ATAN(48)

Output:

atan

DAX atanh(θ) Trigonometric Function

The function ATANH() returns a number’s inverse hyperbolic tangent. The number must be ranged from -1 to 1. (excluding -1 and 1). In other words, ATANH(TANH(number)) equals number. The inverse hyperbolic tangent is the value whose hyperbolic tangent is a number.

Syntax of atanh

ATNH(number)

Example:

inverse hyperbolic tangent of 0.7 in radians.

Formula: atanh = ATANH(0.7)

Output:

atanh

DAX acot(θ) Trigonometric Function

The function ACOT() returns the arccotangent or inverse cotangent, or principal value, of an integer.

Syntax of DAX acot

COT(number)

Example:

The inverse cotangent of 60 in radians.of

Formula: acot = ACOT(60)

Output:

acot

DAX acoth(θ) Trigonometric Function

ACOTH() returns a number of inverse hyperbolic cotangents.

Syntax of DAX acoth

COTH(number)

Example:

The inverses hyperbolic cotangent of 33 in radians.

Formula: acoth = ACOTH(33)

Output:

acoth