dynamic page filter / measure

[Anonymous]

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.

date	measure1	measure 2
31/07/2019	a	12
31/07/2019	b	12
31/07/2019	c	1
31/08/2019	a	1
31/08/2019	b	2
31/08/2019	c	6
30/09/2019	a	3
30/09/2019	b	3
30/09/2019	c	5
31/10/2019	a	4
31/10/2019	b	3
30/11/2019	a	2
30/11/2019	b	1
21/12/2019	a	1
21/12/2019	b	2

[Mariusz · Accepted solution]

Hi @Anonymous 

Maybe you can use Dynamic Date dimension for this

https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.