Select the previous month directly

[Phara]

Hello,

I have a dimension called ''Exercice période'' in French which mean Period exercice. I want to systematically select the previous month of the period in a favorite that I will create, as an example, we're in May, I want to select April.

Any expression for that please?

[HirisH_V7]

By using  trigger in sheets properties with value,

=date(AddMonths(Max(Period exercice),-1),'MMM YYYY')

Do change your format accordingly, get back if any.

[Lech_Miszkiewicz]

Hi @Phara 

• you say: "select the previous month of the period in a favorite"
  • do you want this to be default bookmark of the application?
  • or do you want to have action applying such selection when pening sheet?
• has the 'Exercice période'' field "always one selected value" applied on it
  • if yes and if you want the bookmark to do the job then before you apply bookmark you will have remove always one selected value, clear selections and then set the bookmark as advanced search one with formula ignoring current selection state: like 

    =Only({1}[Exercice période])=Max(Total {1}[Exercice période],2)

  • otherwise yo ucan use @HirisH_V7 ide of sheet triggers but if field has laways one selected value then you still need {1} to omit selection state

cheers