A
C
- CALCULATE
- CALCULATETABLE
- CALENDAR
- CALENDARAUTO
- CEILING
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- COALESCE
- COLUMNSTATISTICS
- COMBIN
- COMBINA
- COMBINEVALUES
- CONCATENATE
- CONCATENATEX
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONTAINS
- CONTAINSROW
- CONTAINSSTRING
- CONTAINSSTRINGEXACT
- CONVERT
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CROSSFILTER
- CROSSJOIN
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENTGROUP
- CUSTOMDATA
D
E
I
N
O
P
R
S
- SAMEPERIODLASTYEAR
- SAMPLE
- SEARCH
- SECOND
- SELECTCOLUMNS
- SELECTEDMEASURE
- SELECTEDMEASUREFORMATSTRING
- SELECTEDMEASURENAME
- SELECTEDVALUE
- SIGN
- SIN
- SINH
- SLN
- SQRT
- SQRTPI
- STARTOFMONTH
- STARTOFQUARTER
- STARTOFYEAR
- STDEVX.P
- STDEVX.S
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUBSTITUTEWITHINDEX
- SUM
- SUMMARIZE
- SUMMARIZECOLUMNS
- SUMX
- SWITCH
- SYD
T
U
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.