Forum Discussion

mvananaken's avatar
mvananaken
Icon for Helper II rankHelper II
9 years ago

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

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 

 

 

Need Help

3 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

    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's avatar
      mvananaken
      Icon for Helper II rankHelper II
      9 years ago

      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

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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