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