Forum Discussion
Compare the daily updated Excel sheets
Data source is Folder, the same format of Excel file is exported and replaced daily in the folder. The visual only need the values in the latest file but if the value is modified since yesterday, th...
Thank you. Ok, need two tables. Now I am trying to find how to move the data from the updated table (today's data) -> to the original table (yesterday's data) automatically when daily refresh. Assume I need the move dataset command like below in red before transforming the latest Excel file. Or set the refresh order, "duplicate the table" should run before "refresh the updated table".
let
Source = Folder.Files("FOLDERPATH"),
ORIGINAL DATASET = UPDATED DATASET, (<- move the table/dataset, but unable to find how to write in M. )
#"then continue the transform on the Source (= today's data)...
Two tables and its data:
| Operation Day | ORIGINAL TABLE (Yesterday's data) | UPDATED TABLE (Today's data) |
| DAY 2 | DAY 1 data | DAY 2 data |
| DAY 3 | DAY 2 data | DAY 3 data |
| DAY 4 | DAY 3 data | DAY 4 data ... continue |
This answer says this cannot be done by Power BI. Anyone comes up with any workaround?