Need help on below scenario

[Prash1283]

I got data having 2 columns (Product and Age) as below and calculate valid event for each product as shown in "Valid event".
I have tried "Earlier"  & Ranking function but could not able get to the full result. Please share your thoughts.

Product	Rank	Age	Valid event
A	1	0	1	Default valid event
A	2	9	1	>= 6 gap from first valid event
A	3	10
A	4	12
A	5	16	1	>= 6 gap from second valid event
A	6	19
A	7	22	1	>= 6 gap from Third valid event
A	8	29	1	>= 6 gap from forth valid event
A	9	30
A	10	36	1	>= 6 gap from five valid event
B	1	0	1	Default valid event
B	2	1
B	3	2
B	4	4
B	5	6	1	>= 6 gap from first valid event
B	6	8
B	7	25	1	>= 6 gap from second valid event

[ERD]

Hi @Prash1283 ,

What makes an event a default one? Age = 0? Do you have dates?

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Prash1283]

Hi ERD

Very first event/age=0/rank=1 all these criteria makes default event. Each event valid event counted as 1.

Using earlier function/ Variable able to identify  >=6 age.  but in some cases like below 16 is valid event and next 22 is valid event but in power bi I could not able to figure how to conditionly earlier valid record with current if corrent row didn't satisfy the >=6 condition.