Forum Discussion
Date Filter in Report Builder
Hopefully this is the right place to ask this.
Also I feel that this must be incredibly simple and I'm just overthinking it. But I swear I've googled all sorts of combinations of 'date range' 'power bi report builder' etc... and couldnt find it.
I have a simple query in report builder that looks like this:
If I execute that query, works great. Problem is, I'd like to set this report up to run weekly and always get the next week of data. So I'd love to change those date filters to something like today() : today() +7 or something like that and for the life of me I cant figure out how.
Based on that screen, or this one
Any ideas?
Hey, do you mean that the date range is not being incluive?
i'm having the same issue,If not, you can set this dynamically with the date/time functions in the expressions
2 Replies
I went about tackling it in a different way, I created a variable that was true/false whether or not it was within 7 days and then set that filter to be "is the variable true".
Hey, do you mean that the date range is not being incluive?
i'm having the same issue,If not, you can set this dynamically with the date/time functions in the expressions
