How to calculate Recent Week and Past Week

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new column.

expected result CC =
VAR _calendartable =
    ADDCOLUMNS (
        CALENDAR (
            DATE ( YEAR ( MIN ( Data[Load Date] ) ), 1, 1 ),
            DATE ( YEAR ( MAX ( Data[Load Date] ) ), 12, 31 )
        ),
        "Year", YEAR ( [Date] ),
        "Weeknumber", WEEKNUM ( [Date], 21 )
    )
VAR _currentweekyear =
    MAXX ( FILTER ( _calendartable, [Date] = TODAY () ), [Year] )
VAR _currentweekweeknumber =
    MAXX ( FILTER ( _calendartable, [Date] = TODAY () ), [Weeknumber] )
VAR _prevweekyear =
    MAXX ( FILTER ( _calendartable, [Date] = TODAY () - 7 ), [Year] )
VAR _prevweekweeknumber =
    MAXX ( FILTER ( _calendartable, [Date] = TODAY () - 7 ), [Weeknumber] )
VAR _currentweeklist =
    SUMMARIZE (
        FILTER (
            _calendartable,
            [Year] = _currentweekyear
                && [Weeknumber] = _currentweekweeknumber
        ),
        [Date]
    )
VAR _prevweeklist =
    SUMMARIZE (
        FILTER (
            _calendartable,
            [Year] = _prevweekyear
                && [Weeknumber] = _prevweekweeknumber
        ),
        [Date]
    )
RETURN
    SWITCH (
        TRUE (),
        Data[Load Date] IN _currentweeklist, "Current Week",
        Data[Load Date] IN _prevweeklist, "Previous Week"
    )