How do I create a new report each month automatically, whilst changing column dates?

[Anonymous]

Hello community,

I have just created my first PowerBI report by using the desktop application to pull data from a Microsoft App using a query (from blank query). I then created a report for it and published it on app.powerbi.com.

In my query, I have specified the dates as Dec 01st - Dec 31st. Is there a way to make a new report automatically each month, whilst it changes the dates to Jan1st - Jan 31st, to get a new report for each month of the year?

[Greg_Deckler · Accepted solution]

@Anonymous - Many times, you create a column to denote the current, day, week, month etc and filter the report based on this filter. In this way, the report always displays the current data.