Forum Discussion

adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
6 years ago
Solved

Always select previous completed month page level filter

Hi Team,   I want page level filter which auomate the process of selection month which is previous completed month. e.g. Current month is May 2020. But I want page level filter who can select Apr...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi  adityavighne ,

     

    Have you checked my reply?

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

adityavighne , you can create a column like this and use in filter

 

Month Name =
var _mm= datediff([date],eomonth(today(),0),month)
return
switch( true(),
_mm =0, "Current Month",
_mm =1, "Last Month",
format([Date],"MMM-YYYY")
)

Month year Sort = format([Date],"YYYYMM") // Optional if you want show in ui.

 

adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
6 years ago

amitchandak 

I'm not looking for this. I want my report always select completed month.

e.g. right now May is running so I want my report must show default data of April which is completed month. Also on 1st June it changes to May

 

regards,

Aditya

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi  adityavighne ,

     

    Have you checked my reply?

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!