Find driving distance and time between two locations

[CloudMonkey]

Hi,

If I have a table of journies - with the starting location in one column in the destination location in anothe column, please can you tell me if it's possible to find the driving distance and travelling time between the two (maybe using bing maps somehow)?

Thanks,

CM

[prateekraina]

Hi @CloudMonkey,

Finding distance between two lat/long points is possible.

Simply google for it and you wil find the DAX expression to derive that.

Prateek Raina

[CloudMonkey]

Thanks @prateekraina is it possible to find the driving distances rather than the "as the crow flies" distances?

[prateekraina]

Hi @CloudMonkey,

Check out this blog by @Phil_Seamark where he shows how to find distance between two points.

Prateek Raina

[jthomson · Accepted solution]

That's not going to help him either. He wants to know a driving distance, and the vast majority of places do not have a perfectly straight road following a great circle between them

OP - not sure if this can easily be done