Adding data from continulously refreshed Table A to historical data Table B.

I'm moving from SAS to Power BI, so trying to convert the coding the best that I can.  In the SAS program the data for the current week is refreshed multiple times a day, after the week is complete ...