Can I visualize two location table on one map? and get distances between two points?

[zeissone]

I have two data table.
Table No.1 : my clients' locations with latitude and longitude.
Table No.2 : realtime earthquake data with ltitude and longitude. (automatically updated every 5min.)
- source link : http://earthquake.usgs.gov/earthquakes/feed/v1.0/csv.php

Question no.1
Can I put two table's lat./long. in one map? I can make two seperated map with each table but I can't make it on one map.

Question no.2
I want to calculate distance between all my clients' location to each earthquake's position.
and I want to show clients' position which is nearby earthquake points (maybe in 100km radius)

[Sean]

@zeissone 

I just answered a similar question on Saturday look here

http://community.powerbi.com/t5/Desktop/Map-multiple-data-sets-on-the-same-map/m-p/129651#M55178

Duplicate post on Service Forum:

http://community.powerbi.com/t5/Service/Can-I-visualize-two-location-table-on-one-map-and-get-distan...

[Greg_Deckler]

I would add a custom column to both queries with static values. For example, a "Type" column with either "Customer" or "Earthquake" as its value. Then, use an append query to append the tables together and use the "Type" column as a legend.

For your other issue, you could either do some type of join where you join your customers with each earthquake row or you could create a measure that does the calculation and perhaps do a matrix visualization with earthquake, client and your measure.

[ericOnline]

Hi @Greg_Deckler , 

Ressurrecting this ancient post here... I followed your advice on appending queries based on a Type column. 
If the two tables have different names for the "lat" and "long" columns, how can I combine these as well in PowerBI?

Thank you!

[Sean]

In the Query Editor rename the lat/long columns in one of the tables to match the names in the other table.

THEN append using either method. That should work 

[ericOnline]

That did it. Thanks!

[zeissone]

I have two data table.
Table No.1 : my clients' locations with latitude and longitude.
Table No.2 : realtime earthquake data with ltitude and longitude. (automatically updated every 5min.)
- source link : http://earthquake.usgs.gov/earthquakes/feed/v1.0/csv.php

Question no.1
Can I put two table's lat./long. in one map? I can make two seperated map with each table but I can't make it on one map.

Question no.2
I want to calculate distance between all my clients' location to each earthquake's position.
and I want to show clients' position which is nearby earthquake points (maybe in 100km radius)

[Seth_C_Bauer · Accepted solution]

@zeissone 

Question no.1
Can I put two table's lat./long. in one map? I can make two seperated map with each table but I can't make it on one map.

You can't have multiple lat/long values. You would need to merge the data and have one table with all lat/long values. Include a column for Type (client, earthquake), then you could use the Type column as a legend to seperate them. This gets you just the differences and locations.

Question no.2
I want to calculate distance between all my clients' location to each earthquake's position.
and I want to show clients' position which is nearby earthquake points (maybe in 100km radius)

There is no mapping feature that comes out of the box in Power BI that will let you do this. You could use R to build maps and determine the distance between points, but you will need to custom build that.