Forum Discussion

2366's avatar
2366
Icon for Helper I rankHelper I
4 years ago
Solved

Filter Dates in Previous Week

Hello,   How do I filter dates in last week (Monday to Sunday) in DAX?    Thanks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi 2366 

     

    Check the formulas.

    weekdays = WEEKDAY('Table'[date],2)

weekstart = 'Table'[date]-'Table'[weekdays]+1

lastweekstart = 'Table'[weekstart]-7

    Combine three formulas:

    Column =
    var week_day = WEEKDAY('Table'[date],2)
    var week_start = 'Table'[date]-week_day+1
    return
    week_start-7
     
    Best Regards,
    Jay
     
2366's avatar
2366
Icon for Helper I rankHelper I
4 years ago

I have something similar which works if all the dates in last week are in the same year but if you have dates from two different year in previous week the above solution wont work?

 

For example - last week dates include 27/12/2021 to 02/01/2022

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

2366 , it should, as we are using week rank, not the week number