Power BI DAX Trigonometric Functions

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 below shown data. As you can see, there are 15 records in this table.

Power BI DAX Trigonometric Functions 1

Power BI DAX Trigonometric Functions

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 cosine value. The syntax of this Power BI DAX COS is as shown below:

COS(expression)

To demonstrate these Dax Trigonometric functions in Power BI, we have to use the Calculated column. To create a column, please click on the New Column option under the Home tab, or Modeling tab.

Power BI DAX Trigonometric Functions 2

As you can see from the screenshot below, we renamed the default column name as COS. The below Power BI DAX Cos statement finds the Cosine value of Grade

COS(EmployeeSales[Grade])

Next, let me add this COS column to the table that we created earlier. Please refer to Create Table Report article to understand the steps involved in creating a table

Power BI DAX COS Function 3

Power BI DAX COSH Function

The DAX COSH function in Power BI returns hyperbolic cosine value. The syntax of this Power BI DAX COSH Function is

COSH(expression)

It returns Hyperbolic cosine value of Grade

COSH(EmployeeSales[Grade])
Power BI DAX COSH Function 4

Power BI DAX ACOSH Function

The Power BI DAX ACOSH function returns the inverse hyperbolic cosine or hyperbolic arc cosine value. This function accepts any real value greater than or equal to 1. The syntax of the Power BI DAX ACOSH Function is:

ACOSH(expression)

It returns Inverse hyperbolic cosine value of Grade

ACOSH(EmployeeSales[Sales])
Power BI DAX ACOSH Function 5

Power BI DAX ACOS Function

The Power BI DAX ACOS function returns inverse cosine value or arc cosine value. This function accepts values between -1 and 1. The syntax of the Power BI DAX ACOS Function is:

ACOS(expression)

It returns Inverse cosine value of COS result

ACOS(EmployeeSales[COS])
Power BI DAX ACOS Function 6

Power BI DAX SIN Function

The DAX SIN function in Power BI returns sine value. The Power BI DAX SIN Function syntax

SIN(expression)

It returns sine values of Grade column

SIN(EmployeeSales[Grade])
Power BI DAX SIN Function 7

Power BI DAX SINH Function

The DAX SINH function in Power BI returns hyperbolic sine value. The syntax of the Power BI DAX SINH Function is:

SINH(expression)

It returns Hyperbolic Sine value of Grade column

SINH(EmployeeSales[Grade])
Power BI DAX SINH Function 8

Power BI DAX ASINH Function

The DAX ASINH function in Power BI returns inverse hyperbolic sine value or hyperbolic arc sine value. The syntax of the Power BI DAX ASINH Function is:

ASINH(expression)

It returns Inverse hyperbolic sine value of Grade column

ASINH(EmployeeSales[Sales])
Power BI DAX ASINH Function 9

Power BI DAX ASIN Function

The Power BI DAX ASIN function returns arc sine value or inverse sine value. The syntax of the Power BI DAX ASIN Function is:

ASIN(expression)

It returns Inverse sine value of SIN result

ASIN(EmployeeSales[SIN])
Power BI DAX ASIN Function 10

Power BI DAX ATAN Function

The Power BI DAX ATAN function returns the inverse tangent value or arc tangent value. The syntax of this Power BI DAX ATAN Function is:

ATAN(expression)

It returns arctangent or inverse tangent value of the Grade column.

ATAN(EmployeeSales[Grade])
Power BI DAX ATAN Function 11

Power BI DAX TAN Function

The Power BI DAX TAN function returns the tangent value. The Power BI DAX TAN Function syntax is:

TAN(expression)

The below statement returns tangent values of Sales column

TAN(EmployeeSales[Sales])
Power BI DAX TAN Function 12

Power BI DAX TANH Function

The Power BI DAX TANH function returns the hyperbolic tangent value. The syntax of this Power BI DAX TANH Function is as shown below:

TANH(expression)

This Power BI DAX Trigonometric function returns Hyperbolic tangent value of Grade column

TANH(EmployeeSales[Grade])
Power BI DAX TANH Function 13

Power BI DAX ATANH Function

The Power BI DAX ATANH function returns an inverse hyperbolic tangent value or hyperbolic arc tangent value. The syntax of this Power BI DAX ATANH Function is

ATANH(expression)

It returns Hyperbolic arc tangent value of TANH result

ATANH(EmployeeSales[TANH])
Power BI DAX ATANH Function 14

Power BI DAX PI Function

The Power BI DAX PI function returns the PI value, i.e., 3.14. The Power BI DAX PI Function syntax is

PI()

Within the below statement, we are dividing the sales values with PI value, i.e., 3.14. You can also use the Divide function to achieve the same.

PI = (EmployeeSales[Sales] / PI())
Power BI DAX PI Function 15

Power BI DAX EXP Function

The Power BI DAX EXP function returns e raised to the power of a given number. The syntax of this Power BI DAX EXP Function is:

EXP(expression)

The below statement returns e raised to the power of grade

EXP = EXP(EmployeeSales[Grade])
Power BI DAX EXP Function 16

Power BI DAX LN Function

The Power BI DAX LN function returns the natural logarithmic value of a given number. The syntax of the Power BI DAX LN Function is:

LN(expression)

The below statement returns the natural logarithmic value of sales

LN = LN(EmployeeSales[Sales])
Power BI DAX LN Functions 17

Power BI DAX LOG Function

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 of the Power BI DAX LOG Function is:

LOG(expression, base_value)

The below Power BI DAX log statement returns the logarithmic value of sales base 2.

LOG = LOG(EmployeeSales[Sales], 2)
Power BI DAX LOG Function 18

Power BI DAX LOG10 Function

The Power BI DAX LOG10 function returns the logarithmic value of base 10 of a given number. The basic syntax of this Power BI DAX LOG10 Function is:

LOG10(expression)

The below statement returns the logarithmic value of base 10 of sales.

LOG10 = LOG10(EmployeeSales[Sales])
Power BI DAX LOG10 Function 19

Power BI DAX RADIANS Function

The Power BI DAX RADIANS function converts the degrees into radians. The Power BI DAX RADIANS Function syntax is

RADIANS(expression)

The below statement converts the Sales values into radians.

RADIANS = RADIANS(EmployeeSales[Sales])
Power BI DAX RADIANS Function 20

Power BI DAX DEGREES Function

The DAX DEGREES function in Power BI converts radians into degrees. The Power BI DAX DEGREES Function syntax is

DEGREES(expression)

The below statement converts the radians values into degrees.

DEG = DEGREES(EmployeeSales[Sales])
Power BI DAX DEGREES Function 21