Daily DAX : Day 347 SINH

Power BI DAX SINH Function

Description

The SINH function in Power BI DAX (Data Analysis Expressions) calculates the hyperbolic sine of a given number. The hyperbolic sine is a mathematical function used in various scientific and engineering calculations, defined as (e^x - e^-x) / 2, where e is the base of the natural logarithm (~2.718).

Syntax

SINH(number)

• number: A numeric value (in radians) for which to calculate the hyperbolic sine.

Return Value

The hyperbolic sine of the input number, returned as a floating-point number.

Use Case

The SINH function is used in scenarios involving exponential growth, physics, engineering, or financial modeling where hyperbolic functions are relevant. For example:

• Physics Calculations: Modeling wave propagation or heat transfer where hyperbolic functions describe certain behaviors.
• Financial Modeling: Calculating growth rates or compounded values in specific financial scenarios.
• Data Transformation: Applying mathematical transformations to data for advanced analytics or visualizations.

Example

Suppose you have a table with a column Value containing numeric data, and you want to calculate the hyperbolic sine for each value.

HyperbolicSine = SINH('Table'[Value])

If 'Table'[Value] contains 1, the result is approximately 1.175 (since SINH(1) = (e^1 - e^-1) / 2 ≈ 1.175).

Notes

• The input must be a numeric value; otherwise, an error is returned.
• SINH is often used alongside other hyperbolic functions like COSH or TANH.
• Ensure the input is in a suitable range, as SINH can produce very large results for large inputs due to its exponential nature.