Power Platform Community Forum Thread Details

I am trying to create a date filter to exclude items where the date is greater than today - 150 days.

Based on some research, I have come up with the below; however, it is excluding Today!

Any help would be greatly appreciated

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

Categories:

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