Report on Current Calendar Month Excluding Today

[Chaipup]

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.

[v-chuncz-msft]

@Chaipup,

In short, this is possible. Here is an example for your reference.

[Chaipup]

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 · Accepted solution]

@Chaipup,

Take a good look at this discussion.

http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373

[Chaipup]

That's great. Thanks for your help.