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
     
Anonymous's avatar
Anonymous
Not applicable
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