TANH
Applies to: Calculated column Calculated table Measure Visual calculation
Returns the hyperbolic tangent of a number.
Syntax
TANH(number)
Parameters
Term | Definition |
---|---|
number | Required. Any real number. |
Return value
Returns the hyperbolic tangent of a number.
Remarks
The formula for the hyperbolic tangent is:
$$\text{TANH}(z) = \frac{\text{SINH}(z)}{\text{COSH}(z)}$$
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
Formula | Description | Result |
---|---|---|
= TANH(-2) | Hyperbolic tangent of -2 (-0.96403) | -0.964028 |
= TANH(0) | Hyperbolic tangent of 0 (0) | 0 |
= TANH(0.5) | Hyperbolic tangent of 0.5 (0.462117) | 0.462117 |