Calculate an active count of consecutive weeks

[salemalnahdi14]

Hi,

Would love some ideas on how to build a column that counts the number of recurring weeks based on a given week.

For example, I have a list of products with weeks purchased:

Product ID	Week of Year (Purchased)
111	22
111	23
222	24
111	24
222	19
333	15
333	16
222	14
444	24
333	20

I want to calculate, the consecutive weeks an item was purchased from week 24. Therefore the new column would look like this based on the data above:

Product ID	Week of Year (Purchased)	Formula
111	22	3
111	23	3
222	24	1
111	24	3
222	19	1
333	15	0
333	16	0
222	14	1
444	24	1

Appreciate the help!

[Felipe_Ribeir0]

Hi @salemalnahdi14 

Try the attached workflow.