Outlook/Excel/Power BI Automatically Calculating Milage

Copper Contributor

I would like to create an excel spreadsheet that automatically pulls data from new/updated calendar events.  Specifically the location is my focus.  I then would like it to calculate the milage automatically from my office location to the location of the calendar event in the same spreadsheet from Google Maps.   

 

This can be through Power BI if excel isn't the way, or if I need to create two excel sheets/books and tie everything together on Power BI.  Thanks!

0 Replies