Relationship issue when i have unique values

[Anonymous]

Hi Experts

Refer to table dimdata and hierarchy both tables have ItemID. I have unique values in Hierarchy table and multiples in dimdata...

When I try and create an 1 to * relationship its telling me I have multiple values in both tables.

https://www.dropbox.com/s/ilpja4jodpl2vei/SampleData_2.pbix?dl=0 

[Fowmy · Accepted solution]

@Anonymous 

Yes, you remove duplicates in Power Query, create the relashionship.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

WebsiteYouTube  LinkedIn

[Fowmy]

@Anonymous 

When you are creating a relationship as one-to-many, the one side of the relationship must have unique values. In your hierarchy table, there are duplicates 3a and 3b. Remove duplicates and it should work.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

WebsiteYouTube  LinkedIn

[Anonymous]

Many thanks for excellent feedback 

[Anonymous]

Just duplicate for 3a and 3b...all other item ids are good?