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 ...
Need Help
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