Sales report to update only showing the current months stats

[CraigBlackman]

Hi All.

Hoping you can help. I have a series of sales reports that i would like to auto update each month to show the current months sats only.

At present I have to go into the report each month and manually set the dates for that month.

I am using a date dimenion table which should hopefully make it easier. I just cannot work out how to do this.

Any help really appreciated.

Thanks

Craig

[v-shex-msft · Accepted solution]

Hi @CraigBlackman,

About dynamic date filter, you can take a look at below blog with power query dynamic date filter.

PowerQuery Dynamic Date Dimension Table Filtering

Regards,
Xiaoxin Sheng