days back based on sum

[bice_cold]

I have a table that looks like this:

DATE         |  IS WORK DAY | IS COUNTED |    ID #

1/1/2018   |           0            |           0          |     123

1/2/2018   |           1            |           1          |      654

1/3/2018   |           1            |           1          |      123

1/3/2018   |           1            |           1          |      654

1/4/2018   |           1            |           1          |      123

I need to calculate for each ID#:

The sum of IS COUNTED in the last 30 work days, annotated in the column IS WORK DAY as a 1.

To get to the end, if one ID # has at least 3 IS COUNTED in the range of 30 work days, I need to flag the ID in a matrix of ID#'s. 

I have a related date table with IS WORKDAY to help with this. Thanks in advance to anyone willing to help!

[v-shex-msft]

HI @bice_cold,

Can you please share some sample data with expected result for test and coding formula?

Regards,

Xiaoxin Sheng