Temporal relationships

[Domski]

Hi,

I have two tables one lists employs with various dates and another a list of pay rates and the dates that they were valid from?

Am I correct in thinking that Power Pivot can't deal with joining these tables and I would have to use formula to bring the rates of pay into the fist table?

Dom

 

[Matt Allington]

Well Power Pivot can definitely deal with it, but it depends what you are trying to do. When you say you have a table of Employees with various dates, what are the dates? Does each employee have only 1 record, or are there multiple records for each employee?

In the Pay Rates table, what is the link to the employee? Is it the employee number or something else?

What is your objective?

 

[Matt Allington]

One more thing. You really should have a star schema data model for this (like I used in the sample). Read about that here. The Optimal Shape for Power Pivot Data -