Skip to main content

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.

power-bi-dax-trigonometric-functions-1-2199717

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.

power-bi-dax-trigonometric-functions-2-9555543

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-trigonometric-functions-3-1722300

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-trigonometric-functions-4-4480464

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-trigonometric-functions-5-5221017

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])
power-bi-dax-trigonometric-functions-6-2171870

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-trigonometric-functions-7-3156865

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-trigonometric-functions-8-5085969

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-trigonometric-functions-9-4929318

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-trigonometric-functions-10-4227173

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-trigonometric-functions-11-7110194

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-trigonometric-functions-12-6518022

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-trigonometric-functions-13-9673307

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-trigonometric-functions-14-4143287

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-trigonometric-functions-15-3507232

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-trigonometric-functions-16-2590923

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-trigonometric-functions-17-1531514

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-trigonometric-functions-18-4924601

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-trigonometric-functions-19-4771372

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-trigonometric-functions-20-4882676

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])
power-bi-dax-trigonometric-functions-21-4832411

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.

power-bi-dax-trigonometric-functions-1-2199717

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.

power-bi-dax-trigonometric-functions-2-9555543

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-trigonometric-functions-3-1722300

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-trigonometric-functions-4-4480464

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-trigonometric-functions-5-5221017

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])
power-bi-dax-trigonometric-functions-6-2171870

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-trigonometric-functions-7-3156865

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-trigonometric-functions-8-5085969

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-trigonometric-functions-9-4929318

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-trigonometric-functions-10-4227173

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-trigonometric-functions-11-7110194

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-trigonometric-functions-12-6518022

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-trigonometric-functions-13-9673307

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-trigonometric-functions-14-4143287

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-trigonometric-functions-15-3507232

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-trigonometric-functions-16-2590923

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-trigonometric-functions-17-9894282

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-trigonometric-functions-18-6567346

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-trigonometric-functions-19-7412893

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-trigonometric-functions-20-3982044

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])
power-bi-dax-trigonometric-functions-21-9783943

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.

power-bi-dax-trigonometric-functions-1-2199717

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.

power-bi-dax-trigonometric-functions-2-9555543

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-trigonometric-functions-3-1722300

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-trigonometric-functions-4-4480464

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-trigonometric-functions-5-5221017

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])
power-bi-dax-trigonometric-functions-6-2171870

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-trigonometric-functions-7-3156865

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-trigonometric-functions-8-1798933

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-trigonometric-functions-9-6312735

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-trigonometric-functions-10-2062321

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-trigonometric-functions-11-9116964

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-trigonometric-functions-12-1063145

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-trigonometric-functions-13-1995659

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-trigonometric-functions-14-4053938

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-trigonometric-functions-15-1832792

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-trigonometric-functions-16-4099339

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-trigonometric-functions-17-9894282

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-trigonometric-functions-18-6567346

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-trigonometric-functions-19-8127028

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-trigonometric-functions-20-9344719

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])
power-bi-dax-trigonometric-functions-21-2107501
R Marketing Digital