Hi,

I have built a database with power query which I'm learning more about each day
I have a record of hours spent at different locations and a couple of master list for locations and rates of pay.

Everything is working fine......untill somebody gets an increment in salary then all the historical data changes too, what would be the best way to keep the historical data and update the new data with current rates?

Any and all suggestions greatly appreciated

Thanks
Kevin