how to find repeated values for same value column but next dates

[Anonymous]

hello

I have multiple factories that I want to monitor thier production by time...

if the production between 2 next dates for a factory remain the same then this factory has something wrong...

factory	date and hour	production
A	21/09/2019 10:00	100
A	21/09/2019 12:01	100
A	22/09/2019 13:02	100
A	22/09/2019 20:03	200
B	21/09/2019 10:04	200
B	21/09/2019 10:05	300
C	21/09/2019 10:06	400
C	21/09/2019 10:07	400

here for example I have 3 faults

I thought a lot how to do it in dax but it blow my mind.... any solutions?

[parry2k]

@Anonymous how come C is red, it doesn't have next 2 days with same value?

[Anonymous]

hello @parry2k 

Thank you for replay and sorry if I didnt gaive a right image for you

but let me clearfy a point you said: 2 days

the bussniss say 2 dates e.g. 2 days, 2 months, 2 hours

any next 2 dates for same factory

and about c>> it has 400 for both 10:06 and 10:07

[parry2k]

@Anonymous I'm still not sure when you say "Next" two days.

I think you mean two transactions including current, regardless of date/time. It is safe to say if production value is same as previous transaction of same factory then make it red.

For me "Next" mean, current transaction and 2 next transactions. May be I'm missing something here.

[Anonymous]

@parry2k 

I think you got the idea...

but 

"I think you mean two transactions including current" YES

"regardless of date/time" NOT 100% true, because the date/time is the unit that I will use to sort the values to know which value is current and which is next

[Anonymous]

No answers??