Number.Sin
NumberReturns the sine of an angle specified in radians.
Syntax
Number.Sin(number as nullable number) as nullable numberParameters
| Name | Type | Required | Description |
|---|---|---|---|
number | number | Yes | The angle in radians. |
Return Value
number — The sine of the angle in radians, in the range [-1, 1].
Remarks
Number.Sin returns the trigonometric sine of an angle measured in radians. The result is always in the range [-1, 1]. Power Query M uses radians throughout — there is no built-in degrees mode. To convert a degree value to radians before passing it to Number.Sin, multiply by Number.PI / 180.
Key reference values: Number.Sin(0) = 0, Number.Sin(Number.PI / 2) = 1 (90°), Number.Sin(Number.PI) ≈ 1.22e-16 (should be 0 but is a tiny floating-point residual due to the irrational nature of π). Use Number.Round if you need clean values for display or comparison.
The sine function is odd (sin(-x) = -sin(x)) and periodic with period 2π. In Power Query, common uses include computing vertical components of vectors, generating wave-shaped patterns in custom data, and performing coordinate transformations.
Examples
Example 3: Sine of 30 degrees — note floating-point imprecision near 0.5
Number.Sin(30 * Number.PI / 180)Result | |
|---|---|
| 1 | 0.50 |