Daily DAX : Day 369 SIN
📐SIN Function in Power BI DAX
🔍 What is SIN?
SIN(angle) calculates the sine of an angle (in radians).
SIN(0) = 0 | SIN(π/2) = 1 | SIN(π) = 0 | SIN(3π/2) = -1
📝 Syntax
SIN(<angle>)
• <angle> = Number (in radians)
• <angle> = Number (in radians)
⚙️ How to Use
Example | Formula | Result | What it does |
---|---|---|---|
45° | SIN(RADIANS(45)) | 0.707 | Sine of 45° |
90° | SIN(RADIANS(90)) | 1 | Sine of 90° |
Column Data | SIN(RADIANS([Angle])) | Calculated | Apply to each row |
🎯 Real Use Cases
Use Case | Formula Example | Business Value |
---|---|---|
📏 Distance Calc | SIN(RADIANS([LatDiff])) | Calculate distances between locations |
📈 Wave Patterns | SIN(RADIANS([Time])) | Model seasonal sales trends |
🔧 Engineering | SIN(RADIANS([Angle])) * [Force] | Calculate force components |
📊 Trigonometry | SIN(RADIANS([Degrees])) | Geometry calculations |
🚀 Quick Start Steps
- Convert Degrees → Radians: Use
RADIANS([Degrees])
- Create Measure:
SineValue = SIN(RADIANS([Angle]))
- Visualize: Add to Line Chart for wave patterns
⚠️ Pro Tips
- Always use RADIANS() for degree inputs!
- SIN returns values between -1 and 1
- Combine with COS() for complete wave analysis
- Great for time-series forecasting
Comments
Post a Comment