Power Pivot Principles: The A to Z of DAX Functions – ACOTH
13 July 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 all a load of hyperbolics…
The ACOTH function
Welcome to the wonderful world of “Functions You May Not Use in This or Your Next Life”. Today’s presentation is on the DAX function ACOTH, which represents the inverse hyperbolic cotangent function. That’s probably as far as I need to go, right..?
If like me, when you were at school you had a life rather than multiple maths lessons, inverse hyperbolic cotangent functions may have passed you by. To understand let’s consider the following functions first:
These sorts of functions are used in differential equations and may also be used to derive trigonometric functions with complex arguments, e.g.
The hyperbolic cotangent function is defined (when x does not equal one ) as follows:
The inverse hyperbolic cotangent function, ACOTH, is the inverse of coth x (above).
For a given value of a hyperbolic function, the corresponding inverse hyperbolic function provides the corresponding hyperbolic angle. The size of this hyperbolic angle is equal to the area of the corresponding hyperbolic sector of the hyperbola xy = 1, or twice the area of the corresponding sector of the unit hyperbola x2 ? y2 = 1, just as a circular angle is twice the area of the circular sector of the unit circle. Some call the inverse hyperbolic functions "area functions" as a consequence.
The syntax is straightforward:
There is only one argument:
- number: the absolute value of which must be greater than one .
Please see my example below:
You see? Who would have thought inverse hyperbolic cotangents in Data Analysis eXpressions would be so easy!
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.