Powerpivot not linking values in tables - it basically does not work

[armastan]

I have two very simple tables:

1. sales
month - product - sales
jan.15 - smth1 - 55
jan.15 - smth2 - 50
feb.15 - smth1 - 5

2. budget
month - product - budget
jan.15 - smth1 - 60
jan.15 - smth2 - 67


Both tables inputed to data models. Products are linked, but still in a pivot table values from one table are not linking to another and i get the following:
month - sales - budget
jan.15 - 105 - 127
feb.15 - 5 - 127

By all means the data model should be working correctly with a such simple example, but it still does not work.
Has anyone had whis problem? WHat could be the solution? Seem like the powerpivot just has a bug or error.

 

[Matt Allington]

I think the most likely explanation is you are not joining your tables correctly. Power pivot is not a relational DB, it is a reporting DB. Both of these tables look like data tables to me. Create a new table called calendar with a single column of all the valid dates - no duplicates. Do the same again and create a product table with a single column of all the valid products. Then connect both of your original tables to these 2 new tables (2 connections each, 4 in total). Make sure the connections place the calendar table and the product table on the 1 side of the relationship. Use the month column from the calendar table and put it on rows in the pivot table. Then it will work.