Introduction
Power BI supports Trigonometric functions. These are very useful to create reports in Power BI. To use these functions, go to the ‘Home’ tab and click on ‘Get Data’. Import data from any source and then go to the ‘Modeling’ tab. Here you get the option named as ‘New Column’, click on it. Here you can write any DAX function that you want to apply on a column. You can also add ‘New Table’ or ‘New Measures’ through the ‘Modeling’ Tab.
The below list of examples shows the Trigonometric functions that are most commonly used.
Functions and Their Description
ACOS
Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi.
Syntax- ACOS(Number)
Number- The number should be from -1 to 1 and cosine of the angle you want
Ex.
ACOSH
Returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number.
Syntax- ACOSH(Number)
Number-Any real number. The number should be equal to or greater than 1.
Ex.
ACOT
Returns the principal value of the arccotangent, or inverse cotangent of a number.
Syntax- ACOT(Number)
Number- The cosine of the angle you want. Must be a real number.
Ex.
ACOTH
Returns the inverse hyperbolic cotangent of a number.
Syntax- ACOTH(Number)
Number-The absolute value of a numbers must be greater than 1.
Ex.
ASIN
Returns the arcsine, or inverse sine, of the number. The arcsine is the angle whose sin is number. The returned angle is given in radians in the range -pi/2 to pi/2.
Syntax- ASIN(Number)
Number- The sine of the angle you want and must be from -1 to 1.
Ex.
ASINH
Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value whose hyperbolic sine is number. So, ASINH(SINH(Number)) equals number.
Syntax-ASINH(Number)
Number- Any real number.
Ex.
ATAN
Returns the arctangent or inverse tangent of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2
Syntax- ATAN(Number)
Number- The tangent of the angle you want.
Ex.
ATANH
Returns the inverse hyperbolic tangent of a number. The number must be between -1 and 1 (excluding -1 and 1). The inverse hyperbolic tangent is the value whose hyperbolic tangent is number, so ATANH(TANH (number)) equals number.
Syntax- ATANH(Number)
Number - Any real number between -1 and 1.
Ex.
COS
Returns the cosine of the given number.
Syntax - COS(Number)
Number - The angle in radians for which you want the cosine.
Ex.
COSH
Returns the hyperbolic cosine of a number.
Syntax - COSH(Number)
Number - Any real number for which you want to find the hyperbolic cosine.
Ex.
COT
Return the cotangent of an angle specified in radians.
Syntax- COT(Number)
Number-The angle in radians for which you want the cotangent.
Ex.
COTH
Returns the hyperbolic cotangent of a hyperbolic angle.
Syntax - COTH(Number)
Number - Any real number.
Ex.
SIN
Returns the sine of the given number.
Syntax - SIN(Number)
Number - The angle in radians for which you want the sine.
Ex.
SINH
Returns the hyperbolic sine of a number.
Syntax - SINH(Number)
Number - Any real number.
Ex.
TAN
Returns the tangent of the given angle.
Syntax - TAN(Number)
Number - The angle in radians for which you want the tangent.
Ex.
TANH
Returns a hyperbolic tangent of a number.
Syntax
Number
Ex.
Summary
Hope you understand these functions and are now able to use them. Thanks for reading!