How to restrict dates column to today's date

[Anonymous]

Hello,

I have the following table and i want to filter only the dates up until today's date. That is, every time the report is refreshed, it should only show all the rows in the table up to today's date. In other words, all the rows with the dates after today's date should be hidden.

Any help would be much appreciated!

Date	Student Name	Submissions	Feedback
03/01/2022	Lizui	4	2
06/01/2022	Laufenburg	7	5
11/01/2022	Tegalpapak	8	8
12/01/2022	Ar Rabiyah	5	6
22/01/2022	Bellegarde	3	8
21/01/2022	Gangarampur	3	3
25/02/2022	Luntas	1	1
26/02/2022	Frei Paulo	6	5
26/03/2022	Seedorf	2	1
03/04/2022	Bellegarde	3	4
05/04/2022	Gangarampur	3	7
11/04/2022	Luntas	1	2
09/05/2022	Cosamaloapan de Carpio	7	3
15/05/2022	Zagrodno	9	9

I placed the table above into a table visualization in Power BI, as shown below. I am also trying to show the title of that table as dynamic with the last date that the data was refreshed. How to do this?

[Anonymous · Accepted solution]

Hi @Anonymous ,

1. Create a flag measure,And apply it to filter pane , set as "is 1":

Flag = IF(MAX('Table'[Date])<=TODAY(),1,0)

2. Create a measure for dynamic header, and apply it to Title Text field in General pane:

Dynamic header = "Date refreshed on "&TODAY() 

Final output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jianlong]

Here is the link for showing refresh date/time. 

https://askgarth.com/blog/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/

You can use the refresh date/time as a benchmark, to select all the rows with time before this.