Only Show Previous Week

Anonymous -

It looks good to me. Only difference I see is:

VAR Current_Week =
    CALCULATE (
        MAX ( [Week] ) - 1,
        FILTER ( vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY () )
    )

versus:

VAR Current_Week =
    CALCULATE (
        MAX ( vw_ShiftsAll[Week] ) - 1,
        FILTER ( vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY () )
    )

Maybe you have something else going on that needs to be known?

Hey,

this DAX statement works in my calendar tables:

isInPreviousWeek = 
var someTestDate = today() -7
var SoWDatePrevWeek = someTestDate  - WEEKDAY(someTestDate,2) + 1
var SoWDate = 'Calendar'[Date]  - WEEKDAY('Calendar'[Date],2) + 1
return
IF(SoWDatePrevWeek = SoWDate, 1,0)

Basically I use this statement to flag some days in my calendar table with flags like

-1 for the previous week

0 for the current week

1 for the upcoming week

Regards,
Tom