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!
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi adityavighne ，

 

I guess you have a date table,right?

Then create 2 calculated columns as below:

 

Date Month is = IF(YEAR('Date table'[Date])*100+MONTH('Date table'[Date])=YEAR( EDATE(TODAY(),-1))*100+MONTH( EDATE(TODAY(),-1)),FORMAT('Date table'[Date],"MMMM"),BLANK())
Date Year is = IF(YEAR('Date table'[Date])=YEAR( EDATE(TODAY(),-1)),FORMAT('Date table'[Date],"YYYY"),BLANK())

 

Finally you will see:

For the related .pbix,pls click here.

 

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