Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: The A to Z of DAX Functions – ACOSH

29 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 ACOSH with no offensive weapon in sight…


The ACOSH function

This function returns the inverse hyperbolic cosine of a number. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number.

The syntax is very simple:

=ACOSH(number)

There is only one argument:

  • number: the cosine of the angle you want and must be greater than or equal to 1.

This function is not supported for use in DirectQuery mode, when used in calculated columns or row-level security (RLS) rules.

Please see my example below:

Another incredible result to add to all my other sarcastic comments…

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