- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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, the value want to be highlited in red.
Yesterday's Excel file
ORDER # | QTY | ETA |
00001 | 10 | 6/1/2022 |
00002 | 20 | 6/1/2022 |
00003 | 30 | 6/2/2022 |
Today's Excel file
ORDER# | QTY | ETA |
00001 | 15 | 6/1/2022 |
00003 | 30 | 6/5/2022 |
00004 | 40 | 6/10/2022 |
Table visual wants to show:
ORDER# | QTY | ETA |
00001 | 15 | 6/1/2022 |
00003 | 30 | 6/5/2022 |
00004 | 40 | 6/10/2022 |
Feeling I need 1) set the datasource = the folder, 2) append the data, 3)Sort by the Excel import date and compare the rows by the Order# of the latest vs the second latest, set the flag which columns have different, 4) Cell font conditional format by the flag.
I need your help how to realize 3) step, or any better workaround?
Thank you so much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @lunako ,
To my knowledge, no, it's not possible in Power BI. Upon refresh it loads the most up-to-date data.
So you may need two tables : Original Table and Updated Table. And then use functions like LOOKUPVALUE() to identify the modified data.
For more information, you may refer to: How to track changes in the table in Power Query - Exceed
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-07-2024 06:32 AM | |||
01-02-2025 02:21 PM | |||
06-07-2024 05:20 AM | |||
10-21-2024 05:12 AM | |||
08-08-2024 04:04 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |