Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
6 years ago
Solved

Filter Date Column by TODAY-7

Hello everyone! I have a date column that I would like to filter on all dates 7 Days before today. Is there any chance to determine that with Power Query?
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi  joshua1990 ， 

    You could try below M code 

    let
    Source = List.Dates(#date(2020,4,12), 30,#duration(1,0,0,0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each if [Column1]<=DateTime.Date(DateTime.LocalNow())-#duration(7,0,0,0) then 1 else 0),
    #"Filtered Rows" = Table.SelectRows(#"Added Custom", each ([Custom] = 1))
in
    #"Filtered Rows"

    Best Regards,
    Zoe Zhi

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