Query to show only newly added records

[Skybluekid]

Hi

I have a small query that is 5K records. What I would like to do is when the query is refreshed, only show the newly added or modified records. Is this possible?

Thanks in Advance.

 

[Skybluekid]

I have found this which seems to work

How to track changes in the table in Power Query - Exceed

In this article, we will show you the way to track changes you make in your Excel table by using Power Query.

exceed.hr