continuous exceed 4 days negative

[pychin]

Hi all

At Power Bi how to make it?

If the customer have negative for continuous 4 days, will automatic show how many days.No matter on which day, as long as continuous 4 days.

example 1: kent continuous already exceed 4 days (negative) , he total got 6 days (negative). then automatic show me 6 days...

example 2: ABBY total got 5 days (negative), but she is not continuous 5 days (negative), so just show me 0...

and make a functions to choose date

like i choose 1/2/2020 to 10/2/2020

Thanks.