DEGREES

How to Use the Power BI DAX function DEGREES

Understanding the DEGREES Function

The DEGREES function in Power BI is used to convert angles from radians to degrees. It takes a single argument, which is the angle in radians that you want to convert. The function returns the angle in degrees as a decimal number.

The syntax of the DEGREES function is as follows:

DEGREES(❰angle❱)

Here, `❰angle❱` is the angle in radians that you want to convert to degrees.

Using the DEGREES Function in Power BI

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

1. Open Power BI and create a new report.

2. Add the data that you want to analyze and visualize to the report.

3. Click the "New Measure" button on the "Modeling" tab of the ribbon.

4. In the "New Measure" dialog box, enter a name for the measure that you want to create.

5. In the formula bar, enter the DEGREES function with the angle in radians that you want to convert as the argument.

6. Press Enter to create the measure.

Here is an example of using the DEGREES function in Power BI. Let's say that you have a table called "Sales" that contains a column called "Angle" with angle values in radians. You want to create a new measure that converts these angles to degrees. Here is how you can do it:

1. Open Power BI and create a new report.

2. Import the "Sales" table into the report.

3. Click the "New Measure" button on the "Modeling" tab of the ribbon.

4. In the "New Measure" dialog box, enter a name for the measure, for example, "Angle in Degrees."

5. In the formula bar, enter the DEGREES function with the "Angle" column as the argument:

Angle in Degrees = DEGREES(Sales[Angle])

6. Press Enter to create the measure.

Once you have created the measure, you can use it in your visualizations just like any other measure.

The DEGREES function in Power BI is a powerful DAX function that enables you to convert angles from radians to degrees quickly and easily. By following the steps outlined in this article, you can use the DEGREES function to create measures that convert angle values in your data to degrees, making it easier to analyze and visualize your data.

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

Upcoming Courses

Contact Us

    Subject

    Your Name (required)

    Company/Organisation

    Email (required)

    Telephone

    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)