increament totals by time and work out max

[Anonymous]

Cust Colum created in my table	Measure that gives me totals	sum b3 to b6
Time	COY Planned (Cumulative)	Excel does  it this way which I can already do in powewr bi very easy	what am struggling with is I need to work out totals by increasing by 1 each time based on time like this is excel
13:00:00	224		1170	sum b3 to b6
13:15:00	356		1700	sum b4 to b7
13:30:00	221		2589	sum b5 to b8
13:45:00	369		5994	sum b6 to b9
14:00:00	754
14:15:00	1245
14:30:00	3626

This is my measure for total shipments

CoyTotal = calculate (countrows(ItemTracking), search("R***C-Normal*", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("LD***-Normal", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("SPUD***-Normal*", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("SVC***-Normal", ItemTracking[Merged],, 0)>0) + calculate (countrows(ItemTracking), search("R*5*C-MAX_R*", ItemTracking[Merged],, 0)>0)

This is my measure that I use to get my max based on the actual hour window, but what I need to check if I had a higher max if the time window was say 13:15 – 14:00

COY Hour = MAXX( KEEPFILTERS(VALUES('ItemTracking'[Hour Window])), CALCULATE([CoyTotal]) )

[v-chuncz-msft]

@Anonymous ,

You may check if the post below helps.

https://community.powerbi.com/t5/Desktop/4-weeks-sales-in-column/m-p/319863#M142375

[Anonymous]

Hi,

I tried to see if i could convert what you had suggested but not having much look.

Here is my table

My code

My Results below which sums all index, i want it to SUM index 0 -3 based on my values in my count colum. I will also need it to be in a if statement that would work out the values based on index 0-3 then 1-4 then 2-5 and so on to give me a column of totals

[Anonymous]

ok, ill take a look thank you