Date Filter - NOT in the next / NOT in the previous

[herschen]

I work for a mortgage company and I want to exclude sale dates that have occurred in the last 12 months and also in the next 5 days from my PowerQuery. Unfortunately, the options for Date Filter from PowerQuery only provide the option to filter "Is in the next" or "Is in the Previous." Is there a way to filter through the PowerQuery to exclude those dates? Right now, I load my report and later filter out through conditional formatting by using this code:

=TODAY()-P1+5 >= 0

This effectively makes it so that any cell with a date in purple has a date that's before 5 days from now. I understand that this code will not work in a PowerQuery since it uses DAX. Any help would be much appreciated. Thanks.