Unable to Create Relationships

[pranim]

I am trying to create relations between tables , by names, which has the data of starts and exits and offers. But i am getting a error saying that, i can't connect the tables as one of the column must have unique values. Start, Exit and offers table have some names in common and some are not....so i was thinking to give many to many or one to one relation.  Please help me. What exactly is the error about.?

Thanks,

Pranitha

[GilbertQ · Accepted solution]

Hi @pranim

When creating a relationship one of the tables always has to have unique values in order to create the relationship. This is by design and how it works, so that it can correctly identify each of the rows.

Here is a good video explaining what relationships are in Power BI

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-2-manage-data-relationships/

What you could do is if you wanted to relate the two tables by a column, you need to create a column that is unique across all the rows in each of your tables, and then create a relationship on those columns from each table. 

[pranim]

Hi Guavaq,

i am experiencing a new problem now.... i have a table with employees full names( obviously there will people with same names but different last names) and the other table i have starts of those employees. However, the starts table has duplicates for 2-3 records. I am trying to make a relation between  the full name table and starts table it is giving me nulls as the values...but there are no null values. If a record is empty it is replaced with NA. why  am i getting null values?

Thnaks,

Pranitha