Hi all
I am trying to get the distance from each employees home address to their place of work. For home address, it is broken into 6 columns, including post code, street address, town/city etc. The work address is simply a single column name of work location.
I am trying to use bing to calculate the latitude and longitude of each address for each person. Thus, I will have a a column for latitude and longitude for home address and work address, and use another method to calculate the distance. I have tried adding a column in power query with the following:
= Table.AddColumn(#"Inserted Merged Column", "Custom", each Json.Document(Web.Content(http://dev.virtualearth.net/REST/v1/Locations?query= & countryRegion="UK"&PostalCode=Text.from([Addressline6]) & locality=Text.From([Addressline4]) & maxResults=1 &key="AuM2IVexzTdbn5uZ8LR1ruMqCle3e0RO6yfghggfhghnewz5hyCmrM_QZAIYW2eU")))[resourceSets]{0}[resources]{0}[point][coordinates]{0}
I get the error: The name 'web.content isn't recognized. Note that I put in a fake key above.
Any idea where I am going wrong?
