Hi Terry,
There is a known limitation in PowerPivot v1 as you can have just one relationship between 2 tables. PowerPivot documentation states:
There can be only one relationship between each pair of tables. That is because the existence of multiple relationships could result in ambiguous dependencies between tables. To create accurate calculations, you need a single path from one table to the next table.
Loops are not allowed among relationships in a Gemini database. In other words, the following set of relationships is prohibited.
Table 1 primary key to Table 2 primary key
Table 2 primary key to Table 3 primary key
Table 3 primary key to Table 1 primary key
To resolve this - load your date table into PowerPivot multiple times and give this table unique name, example : OrderDate, ShipDate, ReceivedDate, etc. Then join each date table back to fact table.
