Forum Discussion
Track changes from dataverse table
- Anonymous2 years ago
Hi mwinds ,
I created some data:
Would you consider adding a time field to the table that records the time of day for all data records, and using measure to determine the date of previous data to highlight?
Customized rules: Previous data date: 2024.2.4
Here are the steps you can follow:
1. Create measure.
color = var _previousdate=DATE(2024,2,4) return IF( MAX('Time_Table'[Date])>_previousdate,"red")2. Select [ID] – Conditional formatting – Background color.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
mwinds , For that you need to create snapshots.
Check if this can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/