Power Query Date filter for not older than Today - 150 Days

Hi Syndicate_Admin  DonalMc 

I'm a bit confused. You want to exclude rows wheer the date is greater than today -150?  But your code keeps those rows?

Your code will exclude today because today falls inside yoru exclusion criteria.  Today's date is greater than today - 150 days.

To keep rows where the date is greater than today -150

= Table.SelectRows(#"Sorted Rows", each Date.IsInPreviousNDays([Finish Date], 150) or [Finish Date] = Date.From(DateTime.LocalNow()))

To exclude these rows

= Table.SelectRows(#"Sorted Rows", each not (Date.IsInPreviousNDays([Finish Date], 150) or [Finish Date] = Date.From(DateTime.LocalNow())))

Phil 

Hi Phil,

Yes - apologies for my clumsiness - I was trying to exclude items that were less than today -150, i.e. only show items that had a date greater than today - 150 days.

Your code helped me, but for some reason excluded items after today. I adapted your code and to the below and now have the result I need.

Thanks for the help

= Table.SelectRows(#"Sorted Rows", each Date.IsInPreviousNDays([Finish Date], 150) or [Finish Date] = Date.From(DateTime.LocalNow()) or Date.IsInNextNDays([Finish Date], 900000) )