Need to always mark the last 7 working days

[Anonymous]

I already have built a holiday table and have a column marking which day's are business days or holidays. My isBusinessDays formula will check  a 1 if it is a business day and 0 if not. 

What I need to create is a new column that will put a 1 or a "yes" on the last 7 business days. This will be rolling, so tomorrow the last business day from yesterday will roll off and a new one will come on if that makes sense. What's a good formula structure to do this? 

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may refer to the DAX below to add a calculated column.

Column =
IF (
    'Table'[Date] < TODAY ()
        && 'Table'[isBusinessDays] = 1
        && COUNTROWS (
            FILTER (
                'Table',
                'Table'[Date] >= EARLIER ( 'Table'[Date] )
                    && 'Table'[Date] < TODAY ()
                    && 'Table'[isBusinessDays] = 1
            )
        )
            <= 7,
    1
)