Date filter for previous month

[pareke03]

Hi Experts,

I have a report that tracks sales performance of the company every day. I have set a relative date filter on my report that filters data for current month which is refreshed automatically on PowerBI service. The data is being pulled every day at 8am for the MTD shipping activity for prior day. Due to this filter we loose visibility of shipping activity of last date of the month (and full month) because on the first date of next month data is being filtered for that month. How can I put a dynamic date filter so that on first date of each month we can still see full view of previous month? Unfortunately I can't put a slicer for month as it won't support my current setup.

Appreciate your time and ideas.

Best,

Keyur Parekh

[v-kelly-msft]

Hi  @pareke03 ,

Sorry I'm a little confused with your requirement,could you pls provide some sample data with expected output for test?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!