Rolling pagefilter based on Firstworkingdate current month till current Endmonth month + 2

[mvananaken]

Hello PB Folks,

I'm looking for a pagelevelfilter to show in a matrix  automatically values from the firstworkingdate in this month till the lastworkingdate for month +2 (in this time line first workingday of Nov 2016 till lastworkingday January 2017). 

I'm specially looking for a " rolling"  filter for my endusers. 

How to achieve this? I've got a datedimension table in my model. 

Thanks!,

Best regards,

Marco 

[v-yulgu-msft]

Hi @mvananaken,

Based on current description, it's not very clear about what is "rolling" filter. Would you please share more detailed information about what you need? If possible, please post some images about your expect output for further analysis.

Thanks,
Yuliana Gu

[BhaveshPatel]

Hi Marco, 

Drag the date column from calender table in the page level filters section, Select advanced filtering where you can see the calender, Select the appropriate value and you are done.

[mvananaken]

Hello @BhaveshPatel

Thank you. I specially looking for some " rolling" time intelligence for my endusers. I know the manually select option, but that's not where I'm looking for.

Best regards, 

Marco