Automatically track price changes over time

[Capybara]

Hello All,

I use an Excel spreadsheet in which new prices are entered daily. The spreadsheet is on a MS Teams folder and is edited in parallel by multiple users. Although a useful change history can be displayed in excel as Change Record (function of shared excel table), it is not possible to use this for deeper analysis.

In addition, it is not possible to use VBA because Teams does not support it. And I dont want to check out (to desktop) the table every time.

I would like to create a dashboard that shows me a change history. For example what has changed from 01/01/2021 to 07/01/2021?  The problem is, when someone enter new value into a cell. The old value is lost and deleted. 

Now I can copy the whole thing manually once a week or month by inserting new columns and copying today's status to the right. That's how I currently do it, but it's absolutely inefficient., error-prone and time consuming. 

Now I have watched videos about Power Automate/Power Query/Power BI, but I find nothing with which I could implement something like this. Or you need the Premium version!

It would be enough for me, if I had a button, which I can press and then automatically the current state in a certain form is copied into a seperate spreadsheet.  

In between (between the current and last data) I need a comparison table, which then always calculates the delta prices (see attachment).

With Power Automate, for example, it doesn't work for me because a button trigger is only available in the premium version and our company doesn't offer this. Furthermore, I wouldn't know if this is the right tool for it.
Does anyone have any idea how to implement something like this? The best would be my team update the table and I still have access to the overwrited data and I could show how the prices increased and decrease over time and which items where changed by whom and maybe also the reasons. 

Is Power BI the right tool? Or do I need something complete different? 

underneath you find an example. My team only add data to table number one.

As you can see on 02.11.2021 is the current status and 01.11.2021 is one day before. Then on 03.11.2021 they update the prices again and Automatically when they have changed the prices for example on daily basis or weekly basis the old prices will be kept and but the prices before the update will be stored next to them on talbe 2. In between you have a comparison talbe that shows you the deltas. 

[AlexisOlson]

The difficult part here is tracking changes between versions. Power BI is not the right tool for this job.

I can imagine this being possible with some combination of SharePoint/OneDrive and Power Automate but I'm not an expert with those and there are separate forums for those.