Keep rows where date is before today

[Rgieltjes_Meyn]

Hi,

I want to keep the rows where the value is before today. The filter needs to be dynamic, so the today filter must change to the current date. 

This is the column for the filter.

Who can help me out?

Thanks

[danextian · Accepted solution]

Hi @Rgieltjes_Meyn ,

If it is in Power Query you can use this code as today's date:

Date.From(DateTime.LocalNow())

In the query editor, filter the column to any date desired and replace the part of the formula which looks like this:

= #date(2023,1,1) //note: do not delete the ) after this.

with

<=Date.From(DateTime.LocalNow())

DateTime.LocalNow() is equivalent to NOW() in DAX or Excel. Since we need to get jus the date component, we then wrap it with Date.From()

[Mahesh0016]

@Rgieltjes_Meyn Please Share Your ENDOUTPUT in table!THANK YOU!!