Power Query new or added items after a refresh

[Kazlik]

I have a table where there is no sequential ID or date that I can sort by. The user will be refreshed it frequently and they would like know what items have been added after each refresh. Is there a way to do this in Power Query?


Initial table

ID
1A'ea
GG14w
T2@T4g


After a refresh I want to note that 13d,4 has been added.

ID
1A'ea
GG14w
13d,4
T2@T4g

 

[ImkeF]

I'm not aware of a function like this in PQ. It even wouldn't work if you duplicate the queries, refresh just one & make a join for a comparison between them both, as it will then refresh the referenced query also.

So the only way I can think of is to write a macro that stores the last result list (before saving the file or before refreshing the new data) in a seperate table. Then do a join between both tables of LeftAnti-Type . This would give you all rows that are not included in the previous version.

Table.NestedJoin(StepNewTable,{"Col1"},OldTable,{"Col1"},"NewColumn", JoinKind.LeftAnti)

 

[Kazlik]

Thanks ImkeF I will give this approach a try.