More trigonometry function to DAX - by Julie Koesmarno

Status : 

 


7
0
Sign in
to vote
ID 774164 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 12/12/2012 2:04:54 PM
Access Restriction Public

Description

Although geographical analysis is now made easy using Power View (with PowerPivot and Tabular model back-end), calculating distance between two points which can be achieved using Trigonometry functions is not possible in DAX.   COS, SIN, TAN, ACOS, ASIN, ATAN etc should be added to the DAX language.

I am sure that there will be other usage for trigonometry functions besides calculating distance between two points that will be useful for other users.
Sign in to post a comment.
Posted by Otykier on 3/18/2015 at 9:14 AM
Another important usage for trigonometric functions is when you need to calculate the average of a cyclical value. For example, average wind direction (0-360 degrees), average time of occurrence of an event that occurs at a random time each day, etc. I had to find a solution for calculating the average wind direction over many wind direction measurements. In the end, I sacrificed some precision in the calculation by creating lookup tables containing precalculated trigonometric numbers (e.g. sin(0), sin(5), sin(10), and so on), but it would have been much easier to simply type a DAX formula using trigonometric functions.
Posted by Erik Roll on 8/7/2014 at 6:02 AM
I completely agree - the mathematical/trig functions should be easy to add, and would enable significant enhancements for mapping and geospatial analysis, as well as other potential use cases. Please add!