Updating table week over week

Hey guys,

I am trying to think of a solution for the following scenario:

We have two tables described below:

(1) Table is updated weekly with a bunch of data regarding the week performance (ex. contains 100+ rows of data and say 10 columns(week(mmddyyy), sales, hours, total, group, state, etc) 

(2) Takes the sum of the values from the current week in the table (1) and creates a new single record (read: row) 

Currently : We have to manually update table 2 by going to excel and summing up each column in table 1. Then taking those summed values and pasting them into table 2. (think of table two as a weekly snapshot) 

Goal : Create an automated process that will look at table 1 date column. 

     If - Table 1 date column is updated (look for the date to change from ex. 6/10/2019 to ex 6/17/2019) 

     Then - create a record (read: row) that is the sum of (ex. sales, hours, etc) columns from table 1. 

     Else - no change

Can we do this in power bi somehow? Whats the trick? 

You guys rock! My actual pbi file cannot be shared. IF this scenario doesn't make sense then I can go try and replicate with fake data.