To use the ATANH function in Power BI, follow these steps:
Step 1: Create a New Measure
First, create a new measure in Power BI by navigating to the “Modeling” tab and selecting “New Measure” from the “Calculations” group. Give the measure a name, such as “ATANH Calculation,” and enter the formula for the ATANH function in the “Formula Bar.”
Step 2: Enter the ATANH Formula
The ATANH formula is as follows:
Replace `❰number❱` with the cell or column reference that contains the number you want to calculate the inverse hyperbolic tangent of. For example, if you want to calculate the ATANH of the number in cell A2, enter the following formula:
Step 3: Apply the ATANH Formula to Your Data
Once you’ve entered the ATANH formula, apply it to your data by dragging and dropping the measure onto your visualizations. For example, if you want to create a scatter plot that shows the correlation between two variables, drag and drop your ATANH measure onto the “Values” field and your two variables onto the “Axis” fields.
Using the ATANH Function in Advanced Calculations
The ATANH function can be used in more advanced calculations as well. For example, you can use the ATANH function to calculate the probability distribution of a set of data by using the following formula:
=ATANH(SQRT(1 - p^2))
Replace `p` with the probability of success and plug the formula into your measure to calculate the probability distribution of your data.
The ATANH function is a powerful tool that can be used in many statistical and mathematical calculations in Power BI. By following the simple steps outlined in this article, you can easily apply the ATANH function to your data and gain valuable insights into your analysis.