SINH

How to Use the Power BI DAX function SINH

What is the SINH Function?

The SINH function is a mathematical function that calculates the hyperbolic sine of a number. The hyperbolic sine is a mathematical function that describes the relationship between the sides of a hyperbolic triangle. It’s similar to the more commonly known trigonometric sine function, but uses hyperbolic functions instead.

In DAX, the SINH function can be used to calculate the hyperbolic sine of a number. The syntax for the function is:


SINH(number)


Where "number" is the value for which you want to calculate the hyperbolic sine.

How to Use the SINH Function in Power BI

Using the SINH function in Power BI is straightforward. To use the function, you'll need to create a measure in your report. Here's how to do it:

1. Open the report in Power BI.

2. Click on the "New Measure" button in the "Fields" pane.

3. In the formula bar, enter the following formula:


SINH([Value])


Where "Value" is the name of the column in your data that contains the values for which you want to calculate the hyperbolic sine.

4. Give the measure a name and click "Enter".

Once you've created the measure, you can use it in your visuals and charts like any other measure.

Example

Let's say you have a data set that contains values for the "Sales" column. You want to calculate the hyperbolic sine of these values. Here's how you would do it:

1. Open the report in Power BI.

2. Click on the "New Measure" button in the "Fields" pane.

3. In the formula bar, enter the following formula:


SINH([Sales])


4. Give the measure a name, such as "SINH of Sales", and click "Enter".

Now you can use the "SINH of Sales" measure in your visuals and charts to display the hyperbolic sine of the sales values.

The SINH function is a powerful tool for performing complex calculations in Power BI. By understanding how to use the function in DAX, you can take advantage of its capabilities to create more insightful and informative reports. Remember to always test your formulas and measures to ensure that they're accurate and provide the results you expect.

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

Upcoming Courses

6-8 Jun 23 (London or Online)
8-10 Aug 23 (London or Online)
24-26 Oct 23 (London or Online)

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)