Forum Discussion
Calculate largest distance between two coordinates
To be able to do such things in a reasonable time you have to pre-calculate the distances between any pair of branches and store this into a physical table in the model. Best would be to calculate this in Power Query or in an outside source system (like, say, SQL). Depending on the amount of data, it may not be feasible to do it in DAX as a calculated table. Once you have such a table, it's then dead easy to find what you want.
danialsj
If you can get the long and lat into tables, then you may able to calculate the distance and compare.Solved: Calculating Distance Between Latitude / Longitude - Microsoft Power BI Community
Use Power Query to Calculate Distance – Girls With Power Tools
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
To be able to do such things in a reasonable time you have to pre-calculate the distances between any pair of branches and store this into a physical table in the model. Best would be to calculate this in Power Query or in an outside source system (like, say, SQL). Depending on the amount of data, it may not be feasible to do it in DAX as a calculated table. Once you have such a table, it's then dead easy to find what you want.