Trigonometric DAX Function In Power BI

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.
 
Trigonometric DAX Function In Power BI 
 
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.
 
Trigonometric DAX Function In Power BI
 
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.
 
Trigonometric DAX Function In Power BI 
 
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.
 
Trigonometric DAX Function In Power BI 
 
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.
 
Trigonometric DAX Function In Power BI 
 
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.
 
Trigonometric DAX Function In Power BI 
 
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.
 
Trigonometric DAX Function In Power BI 
 
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.
 
Trigonometric DAX Function In Power BI 
 
COS
 
Returns the cosine of the given number.
 
Syntax - COS(Number)
 
Number - The angle in radians for which you want the cosine.
 
Ex.
 
Trigonometric DAX Function In Power BI 
 
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.
 
Trigonometric DAX Function In Power BI 
 
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.
 
Trigonometric DAX Function In Power BI 
 
COTH
 
Returns the hyperbolic cotangent of a hyperbolic angle.
 
Syntax - COTH(Number)
 
Number - Any real number.
 
Ex.
 
Trigonometric DAX Function In Power BI 
 
SIN
 
Returns the sine of the given number.
 
Syntax - SIN(Number)
 
Number - The angle in radians for which you want the sine.
 
Ex.
 
Trigonometric DAX Function In Power BI 
 
SINH
 
Returns the hyperbolic sine of a number.
 
Syntax - SINH(Number)
 
Number - Any real number.
 
Ex.
 
Trigonometric DAX Function In Power BI 
 
TAN
 
Returns the tangent of the given angle.
 
Syntax - TAN(Number)
 
Number - The angle in radians for which you want the tangent.
 
Ex.
 
Trigonometric DAX Function In Power BI 
 
TANH
 
Returns a hyperbolic tangent of a number.
 
Syntax
 
Number
 
Ex.
 
Trigonometric DAX Function In Power BI 
 

Summary

 
Hope you understand these functions and are now able to use them. Thanks for reading!