DAX Math & Trigonometric - ACOS function

Description

Returns the arccosine, or inverse cosine, of a number.

DAX ACOS function is new in Excel 2016.

Syntax

ACOS (<number>)

Parameters

Sr.No. Parameter & Description
1

number

The cosine of the angle you want.

It must be from -1 to 1.

Return Value

An angle given in radians in the range 0 (zero) to pi.

Remarks

The arccosine is the angle whose cosine is number.

If you want to convert the result from radians to degrees, multiply it by 180/PI () or use the DAX DEGREES function.

Example

= DEGREES(ACOS(-0.6)) returns 126.869897645844. 
= DEGREES(ACOS(0)) returns 90.
dax_functions_mathematical_trigonometric.htm
Advertisements