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 errors. Any suggestion for this?
Thanks!

 

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


2 Replies

  • 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.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    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