Power Query calculate Count numbers by different dates

Greetings,
I'm trying to figure out a method of checking the difference of counts that change by date.

Example

Source Query:
Name Count Date
John 20 12/24/2019

Next Day Same Query:
John 25 12/25/2019


Output: As of 12/24/2019 John has 5 new....
In a "Landing Table"

Currently I have a source query From .csv: Connection only, Grouped by name, and Added Column "Count" and "Date" with DateTime.LocalNow() as datetime

I'm stuck at a stageing table where i'm trying to add a condidintal column to check the source count and append any changes to the a "Landing Table"

I also have been trgin to modify a fucntion i have that creates a running total here:

Please Login or Register  to view this content.

But i'm stummped or have been staring at the screen to long..

Thanks for any help!

An example of the actual data and expected results would help, that example you give doesn't make a lot of sense to me.

Considering they haven't been created yet I've attempted to replicate what i'd need on a workbook to simulates the Queries and end results

Hi Thank you for the resposne.
I should have mentioned id prefere not to append the table maunally and i'd like to avoid generateing large tables.

Also I was unable to download the file. Not sure if its a site issure or my browers atm.