show data changes in another table

[rakary_10]

Hi,

I have a table where that data is updated in a weekly basis and I need to know everyweek what data has been modified. If possibile even highlight them so that I could track the changes.

Every week there are new rows that are added too in the file and I need those rows to be copied in another table.

Is there are a way to copy all data from the original table to a new table and highlight the changes that have been made? and also copy automatically newly added rows?

Thanks

[MAwwad · Accepted solution]

To copy newly added rows to another table, you can use a Power Query (M) formula to filter the original table for rows that have been added since the last refresh.

AddedRows = Table.SelectRows(Table, each [Modified Date] >= #date(2022, 1, 1))

This formula will return all rows in the table where the "Modified Date" column is greater than or equal to January 1, 2022. You can then use the "Append Queries" feature to append the filtered rows to another table.