Forum Discussion

jimb1955's avatar
jimb1955
Frequent Visitor
4 years ago

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