Count based on date range

[YoussefBelloum]

Hello everyone,

hope you're doing well !

I have a FLAG column  (with value =ok), I would like to count the number of 'ok'  from each date (present in the table) and until an endDate (which is the Date+10 days, which is not calculated yet)

I'll try to explain with the dataset below:

so I need to count the number of FLAG where FLAG equal 'ok' on date range (FabricationDate), starting from the date which is on the line itself until FabricationDate<=FabricationDate + 10 days.

What is need to get is described on the red column (final expression).

Hope it is clear.

Thank you for your time.

Youssef