How can i recall a list value within the same column after regular intervals.

[aporwal]

In below examples,i need a column (Sum of QOH) which has Logic = Sum of P_QOH(W1) + Inbound(W1) - Outbound(W1),
but P_QOH column has values only for week 1 and i need to calculate this for lets say "n" no. of weeks.
even the values which we get in column (Sum of QOH) W1 should behave as value for Sum of P_QOH (W2) for the rest of the calculation so the logic becomes Sum of QOH(W2) = Sum of QOH(W1) + Inbound(W2) - Outbound(W1).
my data is in below format, 

ItemC	Site	Week	Con	Sum of P_QOH	Sum of Inbound	Sum of Outbound	Sum of QOH(desired)
100100	0	1	0-1	520614	0	2163	518451
100100	1	1	1-1	101119	0	1497	99622
100100	2	1	2-1	1562	0	0	1562
100100	3	1	3-1	18062	0	666	17396
100100	4	1	4-1	3300	0	0	3300
100100	5	1	5-1	528	0	0	528
100100	6	1	6-1	396043	0	0	396043
100100	0	2	0-2	0	58894	49597	527748
100100	1	2	1-2	0	0	6256	93366
100100	2	2	2-2	0	0	66	1496
100100	3	2	3-2	0	8228	496	25128
100100	4	2	4-2	0	0	730	2570
100100	5	2	5-2	0	0	0	528
100100	6	2	6-2	0	50666	42049	404660

[Ashish_Mathur]

Hi,

I assume you want a measure (and not a calculated column) solution.  If that is indeed the case, then share share the download link of the PBI file.  Ensure that there is

1. A Date column in your raw data table
2. A Calendar Table with a week number column

[aporwal · Accepted solution]

Hey,
got the solution and it work fine, refer below logic

Sum of QOH(desired)

= SUMX(FILTER(Sheet1,Sheet1[Site]=EARLIER(Sheet1[Site])&&Sheet1[ItemC]=EARLIER(Sheet1[ItemC])&&Sheet1[Week]<=EARLIER(Sheet1[Week])),Sheet1[QOH])

[lbendlin]

Why is the result in Row 3 not picking up the values from rows 1 and 2 ?