Please note javascript is required for full website functionality.
MVP

Blog

Power Pivot Principles: The A to Z of DAX Functions - ASIN

7 September 2021

 

In our long-established Power Pivot Principles articles, we are starting a new series on the A to Z of Data Analysis eXpression (DAX) functions.  This week it’s ASIN with no guilt at all…

 

The ASIN function

The ASIN function returns the arcsine, or inverse sine, of a given number.

The arcsine is the angle whose sine is number.  The returned angle is given in radians in the range (-pi/2) to (pi/2).

The syntax is very simple:

=ASIN (number)

It has only one argument:

  • number: the sine of the angle you want, which must be in the range -1 to 1.

If you want to convert the result from radians to degrees, simply multiply it by 180/PI () or use the DEGREES function.

Please see my example below:

More next time.

 

Come back next week for our next post on Power Pivot in the Blog section.  In the meantime, please remember we have training in Power Pivot which you can find out more about here.  If you wish to catch up on past articles in the meantime, you can find all of our Past Power Pivot blogs here.

 

Newsletter