ASINH

How to Use the Power BI DAX function ASINH

In this article, we’ll take a closer look at the ASINH function and how you can use it in your Power BI reports and visualizations.

What is the ASINH function?

The ASINH function is a mathematical function that’s used to calculate the inverse hyperbolic sine of a given number. In simple terms, it’s a way to calculate the natural logarithm of a number plus the square root of that number plus one.

The syntax for the ASINH function is as follows:


ASINH(number)


Here, the `number` parameter is the value for which you want to calculate the inverse hyperbolic sine.

How to use the ASINH function in Power BI

Using the ASINH function in Power BI is relatively straightforward. Let’s take a look at an example.

Suppose you have a table of data that contains the sales figures for a range of products. You want to create a visualization that shows the sales figures for each product on a logarithmic scale.

To do this, you can use the ASINH function in conjunction with the logarithmic axis option in Power BI. Here’s how:

1. Create a new visual in Power BI and select the table of data that contains your sales figures.

2. Select the column that contains the sales figures that you want to plot.

3. From the Visualization pane, select the Scatter chart icon.

4. From the Fields pane, drag the same sales column to the Values field well.

5. From the X-axis field well, drag the same sales column again to the axis well.

6. From the Formatting pane, select the Y-axis option.

7. From the Type drop-down list, select the Logarithmic option.

8. In the Formula bar, enter the following formula:


ASINH(Sales)


Here, `Sales` is the name of the column that contains your sales figures.

9. Press Enter to apply the formula.

10. From the Formatting pane, select the X-axis option.

11. From the Type drop-down list, select the Logarithmic option.

12. Your visualization should now show the sales figures for each product on a logarithmic scale.

The ASINH function in DAX is a powerful tool for performing trigonometric operations on non-linear data. By using this function in conjunction with the logarithmic axis option in Power BI, you can create visualizations that accurately represent your data on a logarithmic scale.

If you’re new to DAX functions, it can take some time to get used to them. However, with practice, you’ll find that they’re an invaluable tool for working with complex data sets in Power BI.

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)