Automatically update bookmark based on data

[Syndicate_Admin]

Very good!!

It turns out that I have some filters and a "Restart Search" button associated with a bookmark, so that when it is pressed, it returns to that initial state of search.

My problem comes when the data is updated and the last month would correspond to September (for example). Is there a way other than manually changing the bookmark by changing the MES filter to "September", and that change is automatically detected, detecting with some measure or another way the last month uploaded to the file?

Thank you very much in advance.

[Syndicate_Admin]

I understand the functionality of that new column, but I have the problem of being able to take it to a bookmark to change the value of the MES segmentation filter from the previous month to the current month. So far, I'm afraid it's a task to be done by hand, updating the bookmark of that "Reset Search" button.

[amitchandak]

@Syndicate_Admin , You create a column like this and save that on this month or last month

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

refer if needed

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=35