Continuous reduction between rows with criteria

[ADAJALAN]

Help,

I want to determine the column values ​​-/+

This value is taken from the actual column value - the actual value in the previous row

where in determining the -/+ column values ​​are also determined using the same ID criteria

Report Periode	-/+	Plan	Actual
19/07/2024	1%	100%	90%
12/07/2024	4%	100%	89%
05/07/2024	6%	100%	85%
28/06/2024	2%	100%	79%
21/06/2024	2%	100%	77%
14/06/2024	5%	100%	75%
07/06/2024	10%	100%	70%
31/05/2024		100%	60%

[lynchk21]

I am not sure I completely understand, but if you need 

---

@ADAJALAN wrote:

This value is taken from the actual column value - the actual value in the previous row

---

You can try:

[_thisRow].[Actual]-LOOKUP([_thisRow].[_RowNumber]-1,"TableName","_RowNumber","Actual")

[MiguelPilo]

Use the following expression, just replace TABLE_NAME:

[ACTUAL] - ANY(SELECT(TABLE_NAME[ACTUAL],[_RowNumber]=[_ThisRow].[RowNumber]-1))

[TeeSee1 · Accepted solution]

Since you have rows of different IDs intermixed appearing at random you need to use a few constraints to get to the right row.

Report period less than thisrow, ID equals thisrow. Use ORDERBY and INDE X.

[ADAJALAN]

I Used Formula

[PROGESS (ACTUAL)]-INDEX(SELECT(DUPLICATE REPORT[PROGESS (ACTUAL)],and([REPORT PERIODE]=[_ThisRow].[REPORT PERIODE]-7,[ID PROJECT]=[_THISROW].[ID PROJECT])),1)