Relative Date filtering "this month" EXCLUDE today

[Rebecca]

I have a graph showing sales this year and sales last year. I want this to show results for 'this month' which I am able to do using Relative date filtering.

However, on the 1st of the month I still want to show last months results as the data is always 1 day behind.

When you choose relative date filtering "in the last" there is a tick box to exclude or 'Include today'. This tick box would solve my problem but it disapears when you chose 'is in this'. 

Is there another way around this? I am aware of the 'Anchor date' option for Date.value slicers but it is not dynamic and ideally i dont want the user to have to use a slicer.

[v-yulgu-msft]

Hi @Rebecca,

Suppose there is a [Date] column in data table, maybe you could create a calculated column:
New Date=IF([Date]=Today(), BLANK(), [Date])

Then, add this [New Date] column to visual level filter or page level filter, set it fiter syntax to "is in this month".

Regards,

Yuliana Gu

[Rebecca]

Thank you for your suggestion!

It has been requested the report has a Live Data Connection so unfortunatly I don't think I will be able to add any calculated column.