Hi,
I've a date filter in my app which has the dates from 2020 until 2022, I've created a year filter to see only the 2021 and 2022 years in list box using the below expression and is working as expected.
=aggr(only({<Year = {">=$(=year(today())-1)<=$(=year(today()))"}>}Year),Year)
Now my requirement is to create another filter for month and I would like to see data until current month, it means if I select 2021 in year filter I want month's from Jan - Dec and if I select 2022 in year filter I want month's from Jan - July (Current Month).
Regards,
Vikas
@sunny_talwar