Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Relationship issue when i have unique values

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 t...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

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