Building Relationship with tables that do not align.

[Godseyma]

So my company is asking me to compare actual vs budgeted data however the budgeted data table has columns that either do not match or when paired with the Actual data table form a many to many relationship.  I have the Actuals table linked to a calender, customers table, and a item master table and the budgeted data linked to the calender and the customers table. How do I go about linking the Actuals and the budgeted tables together? I am trying to link them on the customers column however the many to many relationship keeps getting in the way. Help please!!!!! Have a blessed day! 

[DataInsights · Accepted solution]

@Godseyma,

The Actuals table and Budget table should not have a relationship with each other. Fact tables should have a relationship with dimension tables, and dimension tables should be used in visuals and filters. Since the Actuals table and Budget table are both linked to the customers table, you can put fields from the customers table in a visual and see both actual and budget amounts.