How to use Power BI DAX trigonometric functions with examples? Microsoft Power BI DAX provides various trigonometric functions such as EXP, COS, SIN, TAN, COSH, ACOS, ACOSH, ASIN, SINH, ASINH, ATAN, ATANH, LN, LOG, LOG10, etc.
To demonstrate these Power BI DAX trigonometric functions, we are going to use the data shown below. As you can see, there are 15 records in this table.
<>Trigonometric functions in Power BI DAX
The following series of examples shows the list of DAX trigonometric functions in Power BI
Power BI DAX COS function
The Power BI DAX COS function returns the value of the cosine. The syntax of this Power BI DAX COS is shown below:
COS (expression)
To demonstrate these trigonometric Dax functions in Power BI, we have to use the Calculated column. To create a column, click the New column option under the Home tab, or Modeling tongue.
As you can see in the screenshot below, we renamed the default column as COS. The following Power BI DAX Cos instruction finds the cosine value of Grade
COS (EmployeeSales [Grade])
Next, let me add this COS column to the table we created earlier. See the Create Table Report article to understand the steps required to create a table.
Power BI DAX COSH function
The DAX COSH function in Power BI returns a hyperbolic cosine value. The syntax for this Power BI DAX COSH function is
COSH (expression)
Returns the value of the hyperbolic cosine of Grade
COSH (EmployeeSales [Grade])
Power BI DAX ACOSH function
The Power BI DAX ACOSH function returns the inverse hyperbolic cosine or the hyperbolic arc cosine value. This function accepts any real value greater than or equal to 1. The syntax for the Power BI DAX ACOSH function is:
ACOSH (expression)
Returns the inverse hyperbolic cosine value of Grade
ACOSH (EmployeeSales [Sales])
Power BI DAX ACOS function
The Power BI DAX ACOS function returns an inverse cosine value or an arc cosine value. This function accepts values between -1 and 1. The syntax for the Power BI DAX ACOS function is:
ACOS (expression)
Returns the inverse cosine value of the COS result
ACOS (EmployeeSales [COS])
SIN function of Power BI DAX
The DAX SIN function in Power BI returns a sinusoidal value. The syntax of the Power BI DAX SIN function
SIN (expression)
Returns sine values of degree column
SIN (EmployeeSales [Grade])
Power BI DAX SINH function
The DAX SINH function in Power BI returns a hyperbolic sine value. The syntax of the Power BI DAX SINH function is:
SINH (expression)
Returns the value of the hyperbolic sine of the degree column
SINH (EmployeeSales [Grade])
Power BI DAX ASINH function
The DAX ASINH function in Power BI returns an inverse hyperbolic sine value or a hyperbolic arc sine value. The syntax for the Power BI DAX ASINH function is:
ASINH (expression)
Returns the inverse hyperbolic sine value of the degree column
ASINH (EmployeeSales [Sales])
Power BI DAX ASIN function
The Power BI DAX ASIN function returns an arc sine value or an inverse sine value. The syntax for the Power BI DAX ASIN function is:
ASIN (expression)
Returns the inverse sine value of the SIN result
ASIN (EmployeeSales [SIN])
Power BI DAX ATAN function
The Power BI DAX ATAN function returns the value of the inverse tangent or the value of the arc tangent. The syntax for this ATAN function in Power BI DAX is:
ATAN (expression)
Returns an inverse tangent or arctangent value from the Grade column.
ATAN (EmployeeSales [Grade])
Power BI DAX TAN function
The TAN function in Power BI DAX returns the value of tangent. The syntax for the Power BI DAX TAN function is:
TAN (expression)
The following statement returns tangent values from the sales column
TAN (EmployeeSales [Sales])
Power BI DAX TANH function
The Power BI DAX TANH function returns the value of the hyperbolic tangent. The syntax for this Power BI DAX TANH function is as follows:
TANH (expression)
This Power BI DAX trigonometric function returns the hyperbolic tangent value of the grade column
TANH (EmployeeSales [Grade])
Power BI DAX ATANH function
The Power BI DAX ATANH function returns an inverse hyperbolic tangent value or a hyperbolic arc tangent value. The syntax for this Power BI DAX ATANH function is
ATANH (expression)
Returns the hyperbolic arc tangent value of the TANH result
ATANH (EmployeeSales [TANH])
Power BI DAX PI function
The Power BI DAX PI function returns the PI value, that is, 3.14. The syntax for the Power BI DAX PI function is
PI()
Within the following statement, we are dividing the sales values with the PI value, that is, 3.14. You can also use the Divide function to accomplish the same.
PI = (EmployeeSales [Sales] / PI ())
Power BI DAX EXP function
The Power BI DAX EXP function returns e raised to the power of a given number. The syntax for this Power BI DAX EXP function is:
EXP (expression)
The following statement returns e raised to the power of degree
EXP = EXP (EmployeeSales [Grade])
Power BI DAX LN function
The Power BI DAX LN function returns the natural logarithmic value of a given number. The syntax for the Power BI DAX LN function is:
LN (expression)
The following declaration returns the natural logarithmic value of sales.
LN = LN (EmployeeSales [Sales])
Power BI DAX log feature
The DAX LOG function in Power BI returns the logarithmic value of a given number. This function accepts a second argument to specify the base value. The syntax for the Power BI DAX logging function is:
LOG (expression, base_value)
The following Power BI DAX log declaration returns the logarithmic value of sales base 2.
LOG = LOG (EmployeeSales [Sales], 2)
Power BI DAX LOG10 function
The Power BI DAX LOG10 function returns the base 10 logarithmic value of a given number. The basic syntax of this Power BI DAX LOG10 function is:
LOG10 (expression)
The following statement returns the base 10 logarithmic value of the sales.
LOG10 = LOG10 (EmployeeSales [Sales])
Power BI DAX RADIANS function
The RADIANS function in Power BI DAX converts degrees to radians. The syntax for the Power BI DAX RADIANS function is
RADIANS (expression)
The following statement converts the Sales values to radians.
RADIANS = RADIANS (EmployeeSales [Sales])
Power BI DAX DEGREES function
The DAX DEGREES function in Power BI converts radians to degrees. The syntax for the Power BI DAX DEGREES function is
DEGREES (expression)
The following statement converts radian values to degrees.
DEG = DEGREES (EmployeeSales [Sales])
