Converting a Excel formula ino DAX

[Anonymous]

Hello all,

I have a question; I use the following excel formula to calculate the difference in KM between 2 lon lat points:

=IFERROR(ACOS(COS(RADIANS(90-E2)) *COS(RADIANS(90-I2)) +SIN(RADIANS(90-E2)) *SIN(RADIANS(90-I2)) *COS(RADIANS(F2-J2))) *6371;0)

(this formula is not mine but one I found on the internet) In the above formula note that:
E2 = LatPoint1
F2 = LngPoint1
I2 = LatPoin2
J2 = LngPoint1

I was wondering if it is possible to convert this formula to a DAX query, since it would be convenient to be able to do this in Power BI.

Thanks in advance,
L.Meijdam

[Omega · Accepted solution]

Try: 

Distance = IFERROR(ACOS(COS(RADIANS(90-[Lat1]))*COS(RADIANS(90-[lat2]))+SIN(RADIANS(90-[Lat1]))*SIN(RADIANS(90-[lat2]))*COS(RADIANS([Lon1]-[Lon2])))*6371,0)

[Anonymous]

Hello @Omega,

Okay this was alot more straightforward than I expected but it works indeed.

Thanks

Best regards,

L.Meijdam