Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 budget figure and today's sales which obviously haven't completed yet so it budget includes the whole of today but sales only upto when the report is run.
My question is: Is there a way of reporting the current month but only up to the day before the report? e.g. Today is the 24th of January so I only want to report from the 1st to 23rd of Jan. I also report the last 7 days in more depth and that allows me to exclude today whereas calendar month doesn't give me that option.
Thanks in advance for your suggestions.
Solved! Go to Solution.
Take a good look at this discussion.
http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373
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
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.
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |