Daily DAX : Day 324 COTH

DAX COTH Function

The COTH function in Power BI's Data Analysis Expressions (DAX) calculates the hyperbolic cotangent of a number. It is a mathematical function used in specific analytical scenarios involving hyperbolic trigonometry.

Syntax

COTH(number)

Parameter:

• number: A real number for which to calculate the hyperbolic cotangent. Must be non-zero.

Return Value

Returns the hyperbolic cotangent of the input number.

Formula

The hyperbolic cotangent is defined as:

COTH(x) = COSH(x) / SINH(x) = (e^x + e^(-x)) / (e^x - e^(-x))

Where e is the base of the natural logarithm (~2.718).

Use Case

The COTH function is rarely used in typical business intelligence scenarios but is valuable in specialized fields like:

• Engineering: Modeling catenary curves (e.g., shapes of hanging cables or chains).
• Physics: Calculations involving hyperbolic relationships, such as in relativity or wave propagation.
• Financial Modeling: Certain advanced financial models involving exponential growth or decay.

Example

Suppose you have a table with a column Value containing numbers, and you want to calculate the hyperbolic cotangent.

CothResult = COTH('Table'[Value])

If 'Table'[Value] contains 1, the result is approximately 1.313 (since COTH(1) = COSH(1) / SINH(1) ≈ 1.313).

Notes

• The input must be non-zero, as COTH(0) is undefined and will return an error.
• Use with caution in large datasets, as it involves exponential calculations that may impact performance.