Dax Function: TANH

Category: Mathematical and Trigonometric Functions

The TANH function in Power BI is a mathematical DAX function that calculates the hyperbolic tangent of a given number. The hyperbolic tangent is a trigonometric-like function used in various mathematical, engineering, and data transformation contexts.

Purpose:

• The TANH function is used to compute values that model hyperbolic relationships. It is particularly useful in scenarios involving growth curves, signal processing, and certain machine learning algorithms.

Type of Calculations:

• The TANH function calculates the hyperbolic tangent of a number using the formula:

​

• The result is always within the range −1 to 1.

Practical Use Cases:

1. Data Normalization: Scale values between −1 and 1.
2. Statistical Modeling: Represent sigmoid-like growth curves.
3. Machine Learning: Activation functions in neural networks.
4. Signal Processing: Analyze and process waveforms.

How Does TANH Dax Function Works?

• The TANH function computes the hyperbolic tangent, which behaves similarly to the regular tangent but for hyperbolic functions:

  1. If the input x approaches positive infinity, the output approaches 1.
  2. If the input x approaches negative infinity, the output approaches −1.
  3. At x = 0, the output is 0.

  Mathematically:

  ​

  Where:

  • ​ (hyperbolic sine)
  • ​ (hyperbolic cosine)

What Does It Return?

The TANH function returns a numeric scalar value between −1 and 1, representing the hyperbolic tangent of the input number.

When Should We Use It?

• Normalizing Data: To scale data values smoothly between −1 and 1 for downstream calculations or visualizations.
• Growth Models: Analyze phenomena with sigmoid-like or s-shaped growth curves.
• Financial Analysis: Model exponential changes in stock prices or interest rates.
• Machine Learning: Use as part of activation functions for neural networks.
•  

Examples

Basic Usage

Calculate the hyperbolic tangent of 1:

Output: 0.7616 (approx).

Column Usage

Apply the hyperbolic tangent calculation to a column of values:

Computes the hyperbolic tangent for each value in the Table[Values] column.

Advanced Usage

Combine the TANH function with other DAX functions for a custom transformation:

Result: Scales the result of the hyperbolic tangent by 10 and adds 5.

Tips and Tricks

• Range Awareness: Use the function to ensure output values are constrained between −1 and 1.
• Avoid Overflows: While the function handles large numbers, be mindful of inputs significantly far from 0, as results quickly asymptote to ±1.
• Combine with Other Hyperbolic Functions: Leverage SINH and COSH for complementary calculations.

Performance Impact of TANH DAX Function:

• The TANH function is computationally efficient for scalar inputs.
• For large datasets, ensure calculations are performed in bulk to minimize performance overhead.

Related Functions You Might Need

• SINH: Computes the hyperbolic sine of a number.
• COSH: Computes the hyperbolic cosine of a number.
• EXP: Calculates e, used in the TANH formula.
• TAN: Computes the tangent of a number (non-hyperbolic).

Want to Learn More?
For more information, check out the official Microsoft documentation for TANH. You can also experiment with this function in your Power BI reports to explore its capabilities.

If you’re looking to unlock the full potential of Power BI and take your data insights to the next level, our expert Power BI consulting services are here to help. Whether you need assistance with implementing advanced DAX functions like the ones discussed here, creating interactive dashboards, or optimizing your data models for better performance, our team of seasoned Power BI consultants is ready to provide tailored solutions for your business. Visit our Power BI Consulting page to learn more about how we can empower your organization with data-driven decisions.