Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Keep rows where date is before today

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

 

 

Need Help
  • danextian's avatar
    danextian
    3 years ago

    Hi Anonymous ,

     

    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()

     

2 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    3 years ago

    Hi Anonymous ,

     

    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()