5.3 How to calculate the distance between 2 locations? [Reporting on maps in Excel & Power BI]

Nothing impresses your audience more than moving data from a table to a map.
Learn how to do it easily with Excel & Power BI.

👉 Sign up for 13 hours of FREE Excel video course (formulas, pivot tables, maps), trusted by 50 000 people, and get all training materials FREE:

Full course playlist:

▼▼▼▼▼▼▼▼▼▼

👉 Subscribe to my YouTube channel:

▼▼▼▼▼▼▼▼▼▼

👉 Reporting on maps in Excel & Power BI course is a great base for further development in Excel - learning about Power Query, Power Pivot, and Power BI. Get 22 hours of Power video course with a 20% DISCOUNT 🏷 by using the code: YOUTUBE.

👉 The package contains:
• 5 hours on Power Query – getting & transforming data in Excel and Power BI
• 5 hours on Data model & DAX for Power Pivot and Power BI users
• 5 hours on Power BI Desktop – the new BI platform from Microsoft
• 7 hours on Data Visualization & Dashboard Design

Our online Academy has been trusted by +1000 companies from all over the world 🌐.

▼▼▼▼▼▼▼▼▼▼

👉 Watch our animations on Power tools to convince your boss 🤴:

▼▼▼▼▼▼▼▼▼▼

👉 We have already trained +100 companies on Power Query, Power Pivot and Power BI. Invite us to your company for the live training:

👉 Check our unique training offer:
• Only practical exercises based on typical challenges you will face in daily life
• Infographic summary of the training
• Post-training task as a follow-up and certification process
• Support after the training included in the price
• We have been a trusted partner of Danone, HSBC, Santander, Roedl, Dentons, MARS, Philips, Schenker, Lufthansa and many more

▼▼▼▼▼▼▼▼▼▼

👉 Questions? Contact me:
Bartosz Czapiewski
Phone: [phone]

[magnatkavuna]

Hi Bartosz, thank you for this wonderful video. Can we use the same formula in case we need to calculate the distance for different shops? For example, Shop 1, Shop 2 and Shop 3 in the same column?

[everchanginglife]

Hello Bartosz, thank you so much for this video! I was wondering how would the formula look if I wanted to measure distance between locations in two rows (one under the other)? And if I didn't want intervals, just exact meters? So sorry, I am a novice at excel... I am using this for my final thesis at college :) Thank you very much in advance!

[arichie]

Can this be done with postcodes? or only by latitude and longitude? Thanks

[tokirodrigo]

Panie Bartoszu, czy jest możliwe ustalenie odległości wynikającej z infrastruktury drogowej pomiędzy dwoma punktami używając Map 3d w Excelu?
Przy okazji świetny kanał

[ikayhargley]

Hi, Thank you for this. Just came across this. is the distance in m or km? thanks

[Mtizozzo]

How can I draw a line between two gps co-ordinates in PowerBI?