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

[snamhoang]

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!

[v-huizhn-msft · Accepted solution]

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]

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.