Calendar week range

Hi, sonya7 

You need to subtract the value of WEEKDAY(_today) in your original formula.

t1 = 
VAR _datetable = DimTarih
VAR _today =
    TODAY ()
VAR _year =
    YEAR ( TODAY () )
VAR _thisyearstart =
    DATE ( _year, 1, 1 )
VAR _year1 =
    YEAR ( TODAY () ) - 1
VAR _yearstart =
    DATE ( _year1, 1, 1 )
VAR _month =
    MONTH ( TODAY () )
VAR _thismonthstart =
    DATE ( _year, _month, 1 )
VAR _thisyearstart1 =
    DATE ( _year, 12, 31 )
RETURN
    UNION (
        ADDCOLUMNS (
            FILTER (
                _datetable,
                [TheDate]
                    > _today - 7
                        - WEEKDAY ( _today )
                    && [TheDate]
                        <= _today - WEEKDAY ( _today )
            ),
            "Period", "Last 1 week",
            "Order", 1
        ),
        ADDCOLUMNS (
            FILTER (
                _datetable,
                [TheDate]
                    > _today - 14
                        - WEEKDAY ( _today )
                    && [TheDate]
                        <= _today - WEEKDAY ( _today ) - 7
            ),
            "Period", "last 2 week",
            "Order", 2
        )
    )

Result:

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.