Forum Discussion

ajitsahoo8338's avatar
ajitsahoo8338
Helper III
1 year ago

How to delete all dates except Previous week date

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 t...
Need Help
Show and Tell
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
1 year ago

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
    )