Connect two tables

[RicardoSousa198]

Good morning,

I'm new to power bi. I've seen a series of videos on youtube and now I'm getting my hands dirty.

I'm trying to link two tables.
A customer table, and a sales table.
I have a problem, in the sales table the only unique field is the customer's name. I don't have the client_id or the taxpayer number.
I try to link the two tables using the customer's name but I can't.
How can I solve?

PS- I used google translator to write this text

Thanks

Ricardo Sousa

[Greg_Deckler]

@RicardoSousa198 The image shown indicates that the tables are linked successfully. Or was this a mock-up of what you want?

[RicardoSousa198]

Hello @Greg_Deckler 

thank you very much for your answer

The image is my connection. The connection works.
As I have the connection made using the client's name, which is not the most correct, because there may be people with the same name, I would like to know if there is any way to make another connection.
What are the best practices in this case?

[Greg_Deckler · Accepted solution]

@RicardoSousa198 Well, the best practice is to use a unique key between the tables but it sounds like you don't have that. I don't know your data, but sometimes its possible to create a unique key column by appending columns together. Like Key Column = [Column1] & "|" & [Column2]. 

But, I don't think that's going to help in your case. You need better data is what it sounds like.