How to aggregate list of dates into one month

[ledi12]

Hi,

I have a field in my datamodel which contains values like:

1/08/2022

2/08/2022

3/08/2022

1/09/2022

2/09/2022

3/09/2022

etc.

I need to create the filter within my sheet which will have the following values:

Aug 2022

Sep 2022

So basically I need to aggregate all dates within the single month into the single month.

How can I do it?

[Vegar · Accepted solution]

You can use monthname() to group your dates into a yearmonth field

Try to use:

monthname([Datefield])

[ledi12]

worked like a charm. Thanks!