Question

A sales manager wants a report page that always shows only the most recent 30 days of transactions, automatically updating each day without anyone editing the report. The date field is a proper Date column. Which approach should you use to satisfy this requirement with the least maintenance?

Accepted Answer

Add a date slicer and set its slicer type to Relative Date, configured to show the last 30 days.

Answer

Add a date slicer set to the Between mode and manually type the start and end dates each morning.

Answer

Create a calculated column flagging rows within 30 days of a hardcoded date, then filter the page by that flag.

Answer

Apply a Top N page-level filter that keeps the 30 highest date values.