Please note javascript is required for full website functionality.
MVP

Blog

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 argument:

  • number – The cosine of the angle you want and must be in the range -1 to 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.

Newsletter