Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Relationship

Hi, Can someone help me here. I am trying to create a trelationship between "SALES" and "BUDGET" but it is not working. I don't want a MANY TO MANY Relationship. Thanks in Advance
Need Help
  • AlB's avatar
    AlB
    3 years ago

    Hi Anonymous 

    If you want a 1-to-many relationship you need to eliminate the duplicates on the the table on the 1 side, in the column you want to use for the relationship.

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

AlB's avatar
AlB
Community Champion
3 years ago

Hi Anonymous 

If you want a 1-to-many relationship you need to eliminate the duplicates on the the table on the 1 side, in the column you want to use for the relationship.

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.