cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Re: Can PBI Desktop calculate the driving distance between points on a map visual?

Hm, that explains how to grab the data in M, but not how to select 2 locations in the report and the query will then request the distance.
So I assume the fact that there's not a real solution out there yet means that you would have to pre-calculate all routes and then write a measure that simply gets the distance value from the table when a countrows-measure equals 2.

Highlighted
Resolver II
Resolver II

Re: Can PBI Desktop calculate the driving distance between points on a map visual?

Dear @fso, If you read the blog posts fully, the latitude and longitude is replaced at the end with input parameter. So, the original query is finally converted to a function which accepts latitude and longitude as input parameter. This function can be used on any new data by defining the latitude field name and longitude field name in the function's parameter

Highlighted
Advocate II
Advocate II

Re: Can PBI Desktop calculate the driving distance between points on a map visual?

Sure, but they question was
"I am trying to find a way to calculate the driving distance between any given two points that are on the map visual."

So i assumed that the goal is to select two points on the map and then get the distance in a measure.
Using the approach you posted you would still have to Pre calculate all possible combinations to achieve this.
Highlighted
Resolver II
Resolver II

Re: Can PBI Desktop calculate the driving distance between points on a map visual?

Ohh, OK. I didn't know your requirement was for dynamic co-ordinates

Highlighted
Helper III
Helper III

Re: Can PBI Desktop calculate the driving distance between points on a map visual?

if you found the solution for the drive distance between 2 points please let me know 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors