ACOTH

Syntax

The syntax for the ACOTH function is as follows:

Where `number` is the numeric value for which you want to calculate the inverse hyperbolic cotangent.

Example

Suppose we have a dataset containing the following values:

| Value |

|——-|

| 0.5 |

| 0.2 |

| 1 |

| 2 |

We want to calculate the inverse hyperbolic cotangent of each value using the ACOTH function. To do this, we can create a new column in our dataset with the following DAX formula:

The resulting table would look like this:

| Value | ACOTH |

|——-|——-|

| 0.5 | 0.5493|

| 0.2 | 1.5375|

| 1 | 0 |

| 2 | -0.5493|

How to Use ACOTH Function in Power BI

To use the ACOTH function in Power BI, you need to follow these steps:

1. Open Power BI Desktop and create a new report or open an existing one.

2. Go to the “Data” tab and select the dataset you want to work with.

3. Click on “Transform Data” to open the Power Query Editor.

4. Select the column for which you want to calculate the inverse hyperbolic cotangent.

5. Click on the “Add Column” tab in the Power Query Editor.

6. Click on “Custom Column” and enter the following formula: `ACOTH([column_name])`

7. Replace `[column_name]` with the name of the column you selected in step 4.

8. Click on “OK” to apply the formula and create a new column with the calculated values.

9. Click on “Close & Apply” to save the changes and close the Power Query Editor.

10. Now you can use the new column with the calculated values in your Power BI report.

The ACOTH function in Power BI DAX is a powerful tool that allows you to perform complex mathematical calculations in your data analysis. By following the steps outlined in this article, you can easily use the ACOTH function in your Power BI reports and gain valuable insights from your data.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

11-13 November 2024

Contact Us