Return null (blank) values and Specific Date Range in Power Query

[herschen]

I'm trying to create a PowerQuery that excludes specific dates. I work for a mortgage company and I need to exclude loans with sale dates in the next 5 days along with any that have already occurred.

I saw in the drop down for Date Filters, it has "Is in the next" and/or "Is in the previous." It unfortunately doesn't have "Is NOT in the next" and/or "Is NOT in the previous." If it had those options, I could exclude any FCL sale dates in the previous 12 months and any FCL sale dates in the next 5 days. Is there DAX code I could insert to create that result?

I decided to try something different since that idea wasn't working. I decided to only include sale dates in the next 3 weeks and also in the next 6 months. There would be times (on Friday) when sale dates that were scheduled for Monday would still show up in the report, but I at least wouldn't be dealing with sale dates in the past. However, the problem with this code is that it excludes any loans with no date listed. I attempted to use the BLANK() Expression, but it came back with the error stating the name 'BLANK' wasn't recognized.

each IsInNextNWeeks([FCL Schedule Sale Date], 3) and [FCL Schedule Sale Date] = BLANK()

Also, the date filter only allows AND twice when it pertains to "In the next." Is it possible to have 3 expressions (obviously, whatever expression needed for 'null' can replace BLANK())

each Date.IsInNextNWeeks([FCL Schedule Sale Date], 3) and Date.IsInNextNMonths([FCL Schedule Sale Date], 6) and [FCL Schedule Sale Date] = BLANK())