How to delete all dates except Previous week date

[ajitsahoo8338]

Hello Everyone,

I have two date fields in my table such as Date 1 & Date 2. But for one Date 2, I want to delete all the dates except the Previous week's date (from the Previous week's Sunday to the Previous week's Saturday). If I add Date 2 to the slicer, it should show dates between the Previous week's Sunday and the Previous week's Saturday. How can I achieve this?

The main requirement is that. I have created this Table.

VAR DateFilter = DATATABLE("Date Filter", STRING,
    {
        {"Last Week"},
        {"Multi Year"}
    }
)
RETURN
DateFilter

If the Selection is "Last week" on Slicer then It should use  Date 2 in the Date Slicer and If the selection is "Multi Year" then it should use Date 1 in the Date slicer.

How can I achieve this?

[Sahir_Maharaj]

Hello @ajitsahoo8338,

Can you please try this approach:

Previous_Week_Filter = 
VAR LastSunday = 
    MAXX(
        FILTER(
            ALL('YourTable'),
            'YourTable'[Date 2] <= TODAY() - WEEKDAY(TODAY(), 1)
        ),
        'YourTable'[Date 2]
    ) - 6
VAR LastSaturday = LastSunday + 6

RETURN
    IF(
        SELECTEDVALUE('DateFilter'[Date Filter]) = "Last Week",
        IF(
            MAX('YourTable'[Date 2]) >= LastSunday &&
            MAX('YourTable'[Date 2]) <= LastSaturday, 
            1, 0
        ),
        1
    )