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

[3lj]

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.

ID	Service
1	Service A
1	Service B
2	Service A
3	Service A

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.

ID	Service	Date	Action
2	Service B	(Date Recorded)	Added
1	Service A	(Date Recorded)	Removed

But I'm completly stumped how to achieve this 😕

Does anyone have any ideas?

[v-cgao-msft · Accepted solution]

Hi @3lj ,

Please check the steps in Power Query Editor to see if it helps.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum