Dynamic date Filters

[jimb1955]

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.

[amitchandak]

@jimb1955 , try this in pace of the date

DateTime.Date(DateTime.LocalNow())

or DateTime.LocalNow()