Forum Discussion

Janka1712's avatar
Janka1712
Frequent Visitor
7 years ago

Not relationship

Hi, I need some help.

 

I have two tables, first table has columns Origin Postal Code and  Destination Postal Code. In second table I have 3 columns:  Postal Codes, Latitude, Longitude. I tried to create relationship but it worked just for one column of postal codes.  I need columns latitude and longitude for both columns Origin and Destination  for visualizations to work.

 

I also tried Lookupvalue but it show  error or blank.

 

 

 

 

 

Need Help

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    Hi Janka1712 

    I’ve created table 1 with Origin Postal Code and  Destination Postal Code, table 2 with Postal Codes, Latitude, Longitude.

    There’s only one active relation available between 2 tables, thus we can create another new table which same as the first one. And then set the single relationship between New table and table 2 using Destination code as the common key. The relationship shown as below:

    Then both original code and destination code could be the filter.  Pbix attached for your reference.

    Regards,

    Dina

    • Janka1712's avatar
      Janka1712
      Frequent Visitor
      7 years ago

      Hi v-diye-msft ,

       

      Thank you, I hoped there is some other way of doing this  without uploading same table twice, but I guess there is no other solution.

       

      Janka