How to Track Rows That Have Added / Removed From A Table?

Hi All,

Hoping to get some assistance with this, we have a table in Power BI that is updated from an external source.

This data can either have rows added to it, or removed from it, and when it does so, the extra lines appear or dissapear when Power BI refreshes.

So in the example above:

- if ID 2 signs up for Serivce B, they will get a row added on update.

- if ID 1 decides to chancel Service A, they will get that row removed on update

What I am trying to do, is track this changes, along with the date they occured.

The idea I had to do this would be to have an extra table, that somehow stores these changes.

So if I actioned the above, this table would have the following lines on it.

But I'm completly stumped how to achieve this 😕

Does anyone have any ideas?