DAX Measure Function DATESINPERIOD - sum while excluding current week

HI coast2coast,

Perhaps you can try to use date function to manually calculate the date range for the calculated conditions:

3weekPrev =
VAR currDate =
    MAX ( Query1[WEEK_START_DATE] )
VAR eDate =
    currDate - WEEKDAY ( currDate, 1 )
RETURN
    CALCULATE (
        SUM ( Query1[DAYS] ),
        FILTER (
            ALLSELECTED ( Query1 ),
            Query1[WEEK_START_DATE]
                >= DATE ( YEAR ( eDate ), MONTH ( eDate ), DAY ( eDate ) - 20 )
                && Query1[WEEK_START_DATE] <= eDate
        )
    )

3weekForward =
VAR currDate =
    MAX ( Query1[WEEK_START_DATE] )
VAR sDate =
    currDate - WEEKDAY ( currDate, 1 ) + 7
RETURN
    CALCULATE (
        SUM ( Query1[DAYS] ),
        FILTER (
            ALLSELECTED ( Query1 ),
            Query1[WEEK_START_DATE] > sDate
                && Query1[WEEK_START_DATE]
                    <= DATE ( YEAR ( sDate ), MONTH ( sDate ), DAY ( sDate ) + 21 )
        )
    )

Regards,

Xiaoxin Sheng