Filter to only show current month and last 12 months in dropdown

[Dushy]

Filter to only show current month and last 12 months in dropdown

[gabibalaban · Accepted solution]

Hi @Dushy ,

So you need  that your dropdown to have as Items the current month and the last twelve months.

Use this in Items formula of your dropdown to get the result in mmmm yyyy format:

ForAll(Sequence(13),Text(DateAdd(Today(),-Value+1,Months),"mmmm yyyy"))

Hope it helps !

[Dushy]

Thanks @gabibalaban 😀