Count consecutives based on an Criteria

[Anonymous]

Hello, i would like to count the number of Events that are out of especificacion (IN = 0, OUT = 1), based on time and criteria,

For example My variable has criteria for every 3 points out, should be an anomaly, but if is for example 10 consecuite points out, it should also count as 1 anomaly, 

VARIABLE

FECHA	HORA I	HORA F		IN = 1, OUT = 0	CRITERIA
1/02/2021	00:00	08:00	2.09	0	3
1/02/2021	08:00	16:00	3.33	0	3
1/02/2021	16:00	00:00	2.13	0	3
2/02/2021	00:00	08:00	4.34	1	3
2/02/2021	08:00	16:00	3.29	0	3
2/02/2021	16:00	00:00	8.81	1	3
3/02/2021	00:00	08:00	9.37	1	3
3/02/2021	08:00	16:00	5.37	1	3

[stevedep]

Can you add expected output to the table?

[Anonymous]

[stevedep]

Thanks, please use the following;

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

[Anonymous]

https://we.tl/t-TRRsCFTW7g