Forum Discussion
jimb1955
4 years agoFrequent Visitor
Dynamic date Filters
How can i make a filtered date dynamic whereas once that current month has passed it'll be filtered out.
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0)
the after date is hard coded to Jun 30 2000, we only want to keep 14 or 16 months worth of data at any one time to prevent the file from getting too large or having to change the filtered date manually.
1 Reply
- amitchandakSuper User