Power Pivot keep historical data

%3CLINGO-SUB%20id%3D%22lingo-sub-3371466%22%20slang%3D%22en-US%22%3EPower%20Pivot%20keep%20historical%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3371466%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20power%20pivots%20to%20track%20the%20performance%20of%20agents%20at%20a%20call%20center.%20I%20have%20a%20Team%20file%20with%20names%2C%20team%20managers%2C%20IDs%2C%20tenure%2C%20etc.%20The%20teams%20will%20change%20ever%20so%20often%2C%20the%20issue%20I'm%20facing%20is%20that%20if%20I%20change%20the%20team%20name%20on%20the%20Team%20file..%20all%20historical%20data%20is%20updated%20with%20that%20new%20team%20change%2C%20I%20would%20only%20like%20the%20new%20data%20to%20be%20updated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20how%20to%20fix%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3371466%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am using power pivots to track the performance of agents at a call center. I have a Team file with names, team managers, IDs, tenure, etc. The teams will change ever so often, the issue I'm facing is that if I change the team name on the Team file.. all historical data is updated with that new team change, I would only like the new data to be updated.

 

Any ideas on how to fix this?

0 Replies