Comparing rows in same table to verify what value has changed

[Tyron]

Hi

I have researched for an answer to this problem but yet to find the right answer.

I have a dataset with columns, ID, Date, Development Type, Delivery Term and would like to see what data has change from one week to the next (if Delivery Term has changed to be specific). All data is within a single table.

I need to be able to show (using conditional formatting, this part I am okay with) rows in a table that have been updated.

Sample Data (visually you can see PRJ003 has had Delivery Term changed, how is the comparison made?)

ID	Date	Development Type	Delivery Term
PRJ001	3/03/2021	New	Term 1
PRJ002	3/03/2021	Improvement	Term 2
PRJ003	3/03/2021	Improvement	Term 2
PRJ004	3/03/2021	Improvement	Term 3
PRJ005	3/03/2021	New	Term 4
PRJ006	3/03/2021	New	Term 4
PRJ001	10/03/2021	New	Term 1
PRJ002	10/03/2021	Improvement	Term 2
PRJ003	10/03/2021	Improvement	Term 3
PRJ004	10/03/2021	Improvement	Term 3
PRJ005	10/03/2021	New	Term 4
PRJ006	10/03/2021	New	Term 4

Thanks and appreciate the assistance

[Syndicate_Admin]

Hello how about I need to compare recipes from the same table, by different scepters, and material to see if they match by the amount loaded in the components:

and put in a column if it matches or not.

[HotChilli · Accepted solution]

This will give you a column of the previous value:

DiffFromPrvWeek = VAR _id = TablePrj[ID]
VAR _term = TablePrj[Delivery Term]
VAR _date = TablePrj[Date]
RETURN
CALCULATE(MIN(TablePrj[Delivery Term]), FILTER(ALL(TablePrj),  TablePrj[ID] = _id && TablePrj[Date] = _date -7))

You can use it to create another column to signal a difference (from delivery term) or use an IF statement within the formula.