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

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

Hi Anonymous,

 

If you want to show the data before the current week by report level filter, I'm afraid that you should type the current week number manually in report level filter.

 

 

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.