Not relationship

[Janka1712]

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.

[v-diye-msft]

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]

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