Forum Discussion
Solved
Report on Current Calendar Month Excluding Today
Hi, I've automated a report in Power BI that reports on the current month's sales and budget and I've used the relative date filter to show the value in this month. However, it reports on today's...
Take a good look at this discussion.
http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373
v-chuncz-msft
Community Support
Community Support
Thanks very much for the feedback. Unfortunately it doesn't quite work as the budget is pre-populated right though this year so I'm still seeing data for today!!! Also the data warehouse updates every half an hour so when sales come through for today it populates the report. Is there a way of purely selecting this month except for today so I can bring in MTD sales and budget?
Kind regards
- v-chuncz-msft
Take a good look at this discussion.
http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373
That's great. Thanks for your help.