COSH

How to Use the Power BI DAX function COSH

Syntax of the COSH Function

The syntax of the COSH function is as follows:


COSH(number)


Where `number` is the value for which you want to find the hyperbolic cosine.

Example Usage of the COSH Function

Let's say we have a table that contains the following data:

| Value |

|-------|

| 1 |

| 2 |

| 3 |

| 4 |

| 5 |

To find the hyperbolic cosine of each value in the table, we can use the following DAX formula:


=COSH([Value])


This will give us the following result:

| Value | COSH |

|-------|--------|

| 1 | 1.5431 |

| 2 | 3.7622 |

| 3 | 10.0677|

| 4 | 27.3082|

| 5 | 74.2099|

Using the COSH Function in Calculated Columns

The COSH function can also be used in calculated columns. Let's say we have a table that contains the following data:

| Value 1 | Value 2 |

|---------|---------|

| 1 | 2 |

| 3 | 4 |

| 5 | 6 |

To create a calculated column that finds the hyperbolic cosine of `Value 1`, we can use the following DAX formula:


COSH([Value 1])


This will create a new column with the hyperbolic cosine of `Value 1`.

Using the COSH Function in Measures

The COSH function can also be used in measures. Let's say we have a table that contains the following data:

| Value 1 | Value 2 |

|---------|---------|

| 1 | 2 |

| 3 | 4 |

| 5 | 6 |

To create a measure that finds the average hyperbolic cosine of `Value 1`, we can use the following DAX formula:


AVERAGE(COSH([Value 1]))


This will give us the average hyperbolic cosine of `Value 1`.

The COSH function in Power BI DAX is a useful tool for finding the hyperbolic cosine of a given number. Whether you need to use the function in a table, calculated column, or measure, the syntax is straightforward and easy to use. By following the examples provided in this article, you can start using the COSH function in Power BI DAX today.

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

Upcoming Courses

15-17 July 2024
16-18 September 2024
11-13 November 2024

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)