Forum Discussion

Maria45's avatar
Maria45
Regular Visitor
7 years ago

Location - Queries

Hello, I am currently modeling the data to analyse the sales in France.

For this, I have two queries:

1. The invoices one (which provides me the sales)

2. The locations map (Departament, city, postal code, country, latitude, and longitude)

 

But I am having a problem when I try to connect the query of location and the sales one; given that some cities are that close that share the same zip code, I am unable to set the country,zip as an identifier, and in that way to connect the queries to visualze my results.

 

Can someone explain me how can I do this?, Please!

 

Thank you so much, 

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Maria45,

     

    given that some cities are that close that share the same zip code, I am unable to set the country,zip as an identifier, and in that way to connect the queries to visualze my results.

     

    Why not use the "latitude" and "longitude" to identify each city?

     

    Regards,

    Yuliana Gu