Dynamic Date Range for multiple pages

[Anonymous]

Hi again,

I have a specific request that I can't find a way to do online. I'm either searching the wrong way, or no one has answered the question. So, I'll ask here, and see what I get.

I have a business report that has 13 sheets (it's Excel, for now). There's a Summary tab, and then 12 sheets, one for each of the previous 12 months. Every month they update the document with new Summary data, and then have the detail data for the new month, REMOVING the 13th tab to make room for it.

I am in the process of converting this report to PBI, and they have, at the moment, indicated that they want the same functionality.

Is there a way to do this in PBI (such that the dates selected for the slicer on each page going back in time are dynamic)?

My thought is *something* like a filter on a measure, but the examples I find aren't actually filtering on the date range in that case.

My end result would look something like:

Current Stats: 10/1/2022-10/31/2022

Page 1: 10/1/2022-10/31/2022 DETAILS

Page 2: 9/1/2022-9/30/2022 DETAILS

Page 3: 8/1/2022-8/31/2022 DETAILS

Such that I wouldn't have to make a change to the PBI report every month....the data set would refresh on a schedule and the visual would update so that the "oldest" month would always be -12 months from today.

Please let me know if that does not make sense.

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

According to your description, you want to see different data in different page  and judge it by the Date. Right?

I think you can try to create a calculated column in your Date Table to judge the Date:

Current Stats: 10/1/2022-10/31/2022

Page 1: 10/1/2022-10/31/2022 DETAILS

Page 2: 9/1/2022-9/30/2022 DETAILS

Page 3: 8/1/2022-8/31/2022 DETAILS

You can compre the [Date] use the TODAY() and EDATE() function, and then you can use SWITCH() function to return the "Flag" to filter your page . 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly