Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter but don't include the current week.

Hi,   My table has a date column & Week column. How do I filter the report using the report level filter to only show data up to but not including the current week?
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

     

    Yes, you could create a calculated column with the formula below.

     

    Column =
VAR week_ = 'Table'[week]
VAR currentweek =
    WEEKNUM ( TODAY () )
RETURN
    IF ( week_ < currentweek, 1, 0 )

    Then drag the calculated column to reported level filter and set like below.

     

     

    Best  Regards,

    Cherry

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-piga-msft,

 

Would it be possible to create a calculated column that I could add in here?

I have a date column that could be used. 

A calculated column that is Current week -1 or something like this?

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous,

 

 

Yes, you could create a calculated column with the formula below.

 

Column =
VAR week_ = 'Table'[week]
VAR currentweek =
    WEEKNUM ( TODAY () )
RETURN
    IF ( week_ < currentweek, 1, 0 )

Then drag the calculated column to reported level filter and set like below.

 

 

Best  Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    That's perfect. Thank you very much.