Forum Discussion
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?
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Yes, it is DateTime.LocalNow I believe. https://www.powerquery.io/date-time/datetime.localnow
Hi joshua1990
You can do it in the Model using Slicer or Filter
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Or you can use Relative Date Dimensionhttps://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.
Please feel free to connect with me.
LinkedInHi 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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
