More trigonometry function to DAX by Julie Koesmarno

Active

Type:	Suggestion
ID:	774164
Opened:	12/12/2012 2:04:54 PM
Access Restriction:	Public

Workaround(s)

view

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.

Details (expand)

English

Analysis Services

Spherical formula to calculate distance between 2 Longitude and Latitude points is as follows (in miles):
=3963*ACOS(
    SIN([@Lat]/57.2957795130823)
        * SIN(POI[Latitude]/57.2957795130823)
    + COS([@Lat]/57.2957795130823)
        * COS(POI[Latitude]/57.2957795130823)
        * COS((POI[Longitude]-[@Lon])/57.2957795130823))

The above formula works in Excel, but not in DAX.

Improved Reliability

Improved usability
Improved adoption

0 attachments

Microsoft