how to create many to many relationship with two duplicated columns in Power Bi Desktop

[dombarg]

hello my frinds.

i got a problem in my data model design.

i have two tables in whitch there are two duplicated columns.how can I create a bridge table (if is neccesary) to handle this issues?

thanks.

following pictures are a screenshot of those tables

as u see, city codes and years are those two column i've said.

[Ashish_Mathur · Accepted solution]

Hi,

Here's an idea.  Using Query Editor, append the City column from both datasets and then remove duplicates.  Save this new one column table as Cities.  Do the same for Years as well.  Then create a relationship.

[Greg_Deckler]

Well, you could create a new column in each, CityYear that combines those values. Then you would just need a bridge table that has all of the distinct values from those columns.

[dombarg]

thank u.very creative solution.i've used this for other problem.