dynamic page filter / measure

Hi All, 

I can only create measures, not columns. 

I have created a page filter for the date column, and I want to filter the 'most recent date' for example 21/12/2019, and also the last three dates which are the last day in the previous months. 
When the database updates overnight, the most recent date changes, for example, 21/12/2019 to 22/12/2019. 

My page filter then removes the most recent but does not select the new most recent.  22/12/2019.  

Is there a way i can solve this with a mesasure.  

I already have a measure built into the database which is a most recent flag..  this show a 1 on all rows with the most recent date, and a 0 on all other row. 

Thanks in advance for any help.