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:
There is only one argument:
- number: the cosine of the angle you want and must be greater than or equal to one .
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.