Datestamp data each day

Hello,

I currently have an excel source where supplier managers of my organisation update rates on their suppliers. This means there are no date stamp on their input since they update the same data to current valid rates.

I am currently tasked to do daily calculations based on these rates but without a date structure i wont be able to compute up against other tables where the rates might have changed in the past.

Is it possible to capture the rate data once each day and datestamp it in PowerBI? Or would you rather suggest i modify the source with date data?

Example

On a given day the data might look something like this:

Another day some of the rates might have changed:

I am looking to date stamp the table each day:

Looking forward hearing any suggestions.

Best Regards