Convert a Formula from looking at months to looking at weeks

[jackj]

I am using the following formula for a calculated column, which works perfectly, to determine if a userID visited in the previous month, and adds a " 1" to the row to signify that that userID visited one month ago.  I am looking to replicate the same thing, except I want to determine if that userID visited one WEEK ago instead.  Below is the formula that works:

Active Last Month = IF(

CALCULATE(

COUNTROWS('warehouse Orders'),

PREVIOUSMONTH('warehouse Orders'[Visit Month]),

ALLEXCEPT('warehouse Orders','warehouse Orders'[UserID])

)

>0,1,0)

[Visit Month] is a calculated column taking the actual order date and putting it in a Month context.  I have a similar column, [Visit Week] which takes the actual order date and converts it to the end of the week.  I am looking to determine if the user visited in the week prior.

Basically, I want to replace the PREVIOUSMONTH('warehouse Orders'[Visit Month]) with a line that does the exact same thing, but looks for the previous week instead.  Any ideas?

[PhilipTreacy]

Hi @jackj 

Try this

Active Last Week = IF(
CALCULATE(
COUNTROWS('warehouse Orders'),
FILTER('warehouse Orders', WEEKNUM('warehouse Orders'[Order Date]) = WEEKNUM('warehouse Orders'[Visit Week]) - 1),
ALLEXCEPT('warehouse Orders','warehouse Orders'[UserID])
)
>0,1,0)

Regards

Phil