Forum Discussion
Solved
Date - Last 7 / 30 days - recurring
I use Power BI desktop. I want to make a report that show users incoming application, and I want it to show number of application last 7 days and last 30 days. And I want this to be recurring date, s...
Hi,
You can set "dynamic filters" as part of your query. It is available to you in the Filter menu (column header dropdown menu) for a DateTime column.
Depending on your queries, you might want to have a common base query and then create two "reference" queries where you define a different filter on each. You could then also disable load for the common base query, and simply load the other two tables with "Last 7 days" and "Last 30 days" data.
Thanks,
M.
vanessa
Post Patron
Post PatronIs there a way to do this, if the 7 days are not calculated from today(), but based on a date selected from a dropdown list.
eg. suppose the date selected in the dropdown is 18/07/2017.
so 7 days before 18/07/2017 should be in the result.