cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Qotsa Regular Visitor
Regular Visitor

Only Show Previous Week

Hi,

 

I have this calc column to only show previous week.

 

Previous Week =
VAR Current_Week = CALCULATE(MAX([Week]) -1, FILTER(vw_ShiftsAll, vw_ShiftsAll[Date] = TODAY()))
RETURN
IF(vw_ShiftsAll[Week] = Current_Week, "Yes", "No")
 

Week Begins on Monday - >

Week = WEEKNUM(vw_ShiftsAll[Date],2)
 
But it's returning dates between 12th March to 17th March.
 
I expected 11th March to 17th March (Monday to Sunday).
 
2 ACCEPTED SOLUTIONS

Accepted Solutions
ChrisMendoza Established Member
Established Member

Re: Only Show Previous Week

@Qotsa -

 

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?

 

1.PNG

 

 

Super User
Super User

Re: Only Show Previous Week

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 

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
2 REPLIES 2
ChrisMendoza Established Member
Established Member

Re: Only Show Previous Week

@Qotsa -

 

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?

 

1.PNG

 

 

Super User
Super User

Re: Only Show Previous Week

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 

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!