Calculating distance between list of coordinates

[some1else]

I wonder if it's possible to calculate each row value distance compared to other rows in a column.

An example:

I know the method to create this in Excel, but I was hoping for some insight into recreating this in PBI, since Excel is limited to 16k columns

The objective is to count the number of ocorrences, given an max distance. Like an heatmap but with numbers 🙂

[v-stephen-msft · Accepted solution]

Hi @some1else ,

You need Latitude and Longitude to calculate the distance between two locations with following formula:

=acos(sin(lat1)*sin(lat2)+cos(lat1)*cos(lat2)*cos(lon2-lon1))*6371

Reference:

Distance Calculation in Power BI
How to calculate lat/long distance

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Calculate all the distances in Power Query, then import the table into Power BI. The table can be of the form:

Left Point | Right Point | Distance

------------------------------------

From this it'll be dead easy to create what you want.