Forum Discussion

snamhoang's avatar
snamhoang
New Member
9 years ago
Solved

[Need Help] Create Filter to Display the last 5 weeks

Hi guys, I have the data with the period of the last 10 weeks' performance. However, I only wanna display the last 5 weeks' by creating a filter with the script as in the photo. Yet it shows some ...
Need Help
Show and Tell
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi snamhoang,

    Your formula shows some errors, because you create a measure rather than calculated column. You should create a calculated column which will used to filter your report as Phil_Seamark posted.

    Best Regards,
    Angelia


Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi snamhoang,

 

If you have a calendar/date table, you could add this column to it

 

Weeks From Today =  IFERROR( DATEDIFF('Dates'[Date],TODAY(),WEEK),-1)

Then you can include it in your Page, Report or Visual level filter to show where the value is >0 and < 5 

 

This gives you the flexibility to choose different ranges.