### 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.
Details
**Category**

Analysis Services

Proposed Solution

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.

Primary Benefit

Improved Reliability

Other Benefits

Improved usability

Improved adoption