Forum Discussion
Solved
show data changes in another table
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. Ever...
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.
MAwwad
Solution Sage
Solution SageTo 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.