effective date

Hi Everyone, I am working on a document trying to compile monthly purchases of parts for the year. The biggest obstacle I am facing is that the pricing for different parts changes at different points throughout the year. Currently I have one table listing each part with the effective and...

Hi All, I am unable to figure out how do i map data based on effective date i have a record with transaction date, owner of transaction and another table which maps owner with department and effective date which tell me if an owner was transferred to a different dept and its effective date...

I have a set of performance data by Region, and I would like to merge this data with the appropriate Manager Name. In Power Query, a simple Left Outer Join does the trick in the normal situation where a Manager is assigned one or more regions for the entire Data Set. My problem lies in how to...

<TBODY> ColumnA ColumnB ColumnC EffDate Dept Uptime% 02/01/12 Sawmill 85% 02/01/12 Planer 83% 05/01/12 Sawmill 86% 06/01/12 Planer 84% 07/01/12 Sawmill 86.5% 07/01/12 Planer 84.5% </TBODY> I have a table (uptimeTable) setup as above to capture Goals for...