Two-column PowerPivot ratio per table

Question

I have a geoLocations table that contains, among others, two latitudes and longitude columns. There is a second table (let it be called cities), which contains for each unique pair of loyalty and longitude the corresponding city.

How to model this relationship using PowerPivot? Creating two separate relationships will fail, because one coordinate can occur several times in the lookup table (only a combination of both is unique).

Thank you in advance:)

Answer 1

You must create a key in each table that combines 2 fields together. This can be done in the calculation column, for example:

= LATITUDE and "-" and LONGITUDE

Or with an import that provides better performance in a large dataset.

Jacob