Accruing values weekly

Hi Jeff2Jets ,

 lets do it together.

1-after loaded the weeks, append queries as new in power query:

2- append the table like bellow and hit ok:

Now you data should look like this:

3- Now select the employee name and department and right click on them and choose group by:

4- now make sure that you fill the fields like this and hit ok:

Now your data should look like this:

As you can see is now showing your desired result

5- now disable the load for week1 and week 2, because we will not use them:

After disabled week1 and week2 tables, now you can rename the appended table to your desired name and close and apply.