Trigonometric DAX Function In Power BI

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.

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.

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.

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.

Returns the inverse hyperbolic cotangent of a number.

Syntax- ACOTH(Number)

Number-The absolute value of a numbers must be greater than 1.

Ex.

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.

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.