Hello, this is my scenario:
I have a data model with incremental refresh already established. My data source is Google Big Query which already has the current data coming in to my report. I have a request from the business asking me to limit my incoming data to 5 days prior to the current date for every given day at the dataset level.
I tried creating a calculated column on my date table to be used as a page level filter, but was rejected.
This is the idea they want to see: They want to see past data up to (currentdate - 5) at the dataset level.
Thanks