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...
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.