Allocating budget salaries for Leavers/Starters|Power Query|Excel Forum|My Online Training Hub

Hi

I have a situation where I have the budget for salaries, however when a person either starts or finishes, the budget file has the name of the person from the budget however I want to be able to change that to the current person or vacant.

The budget file has position number, name, account, date and amount. A table for additions and one for terminations.

What I am trying to do is if an employee leaves then I want to be able to replace that persons name with either vacant or with the name of the new person as they will take on the budget number going forward based. Also, if the budget has vacant to replace the vacant with the name of the new employee.

Not sure if Power Query is the way to go or do it through DAX.

I have attached a file that shows how the data looks and what it should look like.

Thanks

Jon