Snapshot fact table where data is deleted

Hello everyone,

I have a table that has rows regularly added and removed from it.

Once a day, I want it to take a snapshot of what it looks like at that specific moment in time, and be able to pull this into an excel sheet or somewhere where I can then analyse it again in PowerBI.

Sample data (Figure 1):

Desired result (Figure 2):

However, the key thing to remember is that projects in Figure 1 may be removed, so it would have to save the data somewhere.

My initial thinking is that I need a way to essentially download a summary of that data, which I can then re-pull back into PowerBI to do further analysis.

Any resources or help would be great

Thanks,

Tom