Relationship table - Actual to Budget

[voiciK]

Hi All,

I am new to Power BI and do not fully understand the relationship among tables.

I cannot workout how to set up the relationship between the actual and budget tables.

So my Actual table is:

And my Budget table is:

I want to create a matrix report to compare actual & budget data, and put a filter to Store & Date range. Something like this:

I tried creating a Date table & a Store table then link the actual & buget to these 2 tables but I think I did something wrong. Here are my links:

I linked the Date from Date_Table to the Date in 2 main datasets.

Then Store from Store list to Store in 2 main datasets.

Finally link the Product of 2 main datasets together.

These are the Fields I used:

Thank you for your help!

[amitchandak · Accepted solution]

@voiciK , You should not join Fact. You should have join between actual and budget . If need create a common product dimension.

remove that join and correct rest of the joins

[voiciK]

Thanks I fixed it! 👍