Date Flags

[jbwelch2]

I have a situation where a business system will update dates (both dates in the future) in the same column and will not alert a user a date has been changed.  I pull this information from a dataflow that is updated daily. 

What I need to understand is how can I flag a date change for review in PowerBI?  I've made a very generic table showing what I need.   Is there any way to compare values or at least flag it if there was a date change, but the data source is always in the same column in the dataflow?

Checked:  11/1/2024
Order	Order Status	Dates
123	Open	11/15/2024
456	Open	11/20/2024
789	Open	11/17/2024

Checked:  Today
Order	Order Status	Dates
123	Open	11/25/2024
456	Open	11/20/2024
789	Open	12/1/2024

[lbendlin · Accepted solution]

Power BI has no memory* . You need to manage your snapshots in the upstream system. * Yes, there is the self referencing option but that has no safety net.

[Omid_Motamedise · Accepted solution]

If these two tables are the result of same query, you can export the previous result into CSV by using python or R and then compare the result of today table with the result of last CSV file, and if these two tables are seperate query, you can use merge to extract the differences.code into CSV file and 

[lbendlin · Accepted solution]

Power BI has no memory* . You need to manage your snapshots in the upstream system. * Yes, there is the self referencing option but that has no safety net.