Last 3 "Periods" date range filter

[TayVanderchys]

Hi,

I'm hoping this is possible, basically I have a calendar table fully loaded and set up, data is all working, I just need to be able to slice on my custom "4 week periods" I have setup.. The column is called "Period Year", and basically is period 1 to period 13.

I want there to be some sort of rolling data range, which only takes the LAST 3 FULL PERIODS..

Meaning, if we are currently half way through period 5 at the moment.. I want the data to be filtered on: Period 4, Period 3, Period 2

Once we tick over into period 6, I want that to AUTOMATICALLY change to period 5, period 4 and period 3.

I'm presuming this will work the same as the "month" column in any calendar. 

Any help is greatly appreciated.

Thank you!

[v-qiuyu-msft]

Hi @TayVanderchys,

How did you create "Period Year" column? Would you please share some sample data?

As you mentioned "if we are currently half way through period 5 at the moment.. I want the data to be filtered on: Period 4, Period 3, Period 2", did you mean for those records in period 5 will have another column display the total of Period 4, Period 3, Period 2 values? If possible, please share some screenshots to clarify the requirement.

Best Regards,
Qiuyun Yu

[MFelix]

Hi @TayVanderchys,

In the May updated the date slicer was updated with relative dates check the link below

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/

Mfelix