Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ajitsahoo8338
Helper III
Helper III

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 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?

1 REPLY 1
Sahir_Maharaj
Super User
Super User

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
    )

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution? (Yes, its FREE!)
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.