Hi,

I am working with the PowerPivot addin.

What I have is two tables

Table1
Pol ------------ Date
1 ------------ 8/8/11
4 ------------ 8/10/11
5 ------------ 8/8/11
6 ------------10/11/11
8 ------------ 9/10/11
9 ------------ 7/6/10


Table 2
Pol ------------- Date
1 ------------- 8/8/11
2 ------------- 8/13/11
3 ------------- 8/10/11
4 ------------- 8/10/11
5 ------------- 8/9/11
6 ------------- 11/10/11
7 ------------- 11/12/11
8 ------------- 9/10/11
9 ------------- 7/4/10

I have a relationship from table 2 to table 1 with Pol. Where Pol in Table one is acting as my Primary Key, and in table two is is just another foreighn key among others. what i would like to do is to establish a relation between the dates as well, but as you may know PowerPivot does not allow multiple relationships between two tables. What I am trying to obtain in my Pivot Table is to show the Pol and Date when Pol in Table 1 = Pol in Table 2 AND when Date in Table 1 = Date in Table 2, so the result would look like this:

Pol ----------- Date
1 ----------- 8/8/11
4 ----------- 8/10/11
8 ----------- 9/10/11

I know how to do this query in Access but my data is too large to fit in Access, so I am attempting to do this in PowerPivot. Any help is greatly appretiated,

Thank You