Power Pivot keep historical data

Copper 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