Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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)
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)
Hello @Omega,
Okay this was alot more straightforward than I expected but it works indeed.
Thanks
Best regards,
L.Meijdam
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
104 | |
93 | |
70 |
User | Count |
---|---|
173 | |
134 | |
132 | |
101 | |
95 |