Parameter e.g. last week
For a couple of dashboards i want to just go through data-rows of the last week. Is it possible to create a date-parameter that shifts with the actual date? So the report can evaluate only the rows from last week, counting from today.
Leon Poels commented
Thank you Justin. I'm not a very pro user of PBI but i think I mean something else:
I try to limit the amount of data that my dashboard has to go through by using parameters in the query-editor. Here I include a filter like ""starting date" on the date column. Correct me if I'm wrong but this would limit the actual data underlying the report?
If I can apply a parameter which filters on only the last 7 days (in query editor), my dashboards would be a lot faster since there are less rows in the datasheet.
Justin Hylton commented
Yes, one way is to write measures that use CALCULATE() with filters like 'Dim Date'[Date] >= TODAY() - 7.
Another is to use relative date slicers on your report page and set it to "Last" "1" "Weeks".