Power Pivot Principles: The A to Z of DAX Functions – ACOS
22 June 2021
In our long-established Power Pivot Principles articles, we are starting a new series on the A to Z of Data Analysis eXpression (DAX) functions. This week it’s ACOS with no lettuce in sight…
The ACOS function
The ACOS function returns the arccosine, or inverse cosine, of a given number.
The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range zero [0] to pi.
The syntax is very simple, even if the principle is a little tangential (get it?):
=ACOS(number)
There is only one [1] argument:
- number – The cosine of the angle you want and must be in the range minus one [-1] to one [1].
If you want to convert the result from radians to degrees, multiply it by 180/PI() or use the DEGREES function.
Please see my example below:
Amazing!
Come back next week for our next post on Power Pivot in the Blog section. In the meantime, please remember we have training in Power Pivot which you can find out more about here. If you wish to catch up on past articles in the meantime, you can find all of our Past Power Pivot blogs here.
