Power Query - Date Filter | Not last 2 Weeks

[Power-CJ]

Hi there,

i can't find a Filter-Operation like "Not in Last X days/weeks".

In my Case i want to analyse only data with a timestamp from the last 2 years but exclusive the last 2 weeks.

There is an M-Operator for the previous x weeks. Can i negate this command?

greets  

[Power-CJ]

@amitchandak 

thanks a lot!

Yeah its really so easy by adding additional colum

[amitchandak · Accepted solution]

@Power-CJ , What we do we create a filter and then change the code suite the requirement

or create a column and filter it

Date.IsInCurrentWeek, Date.IsInNextWeek, Date.IsInPreviousWeek: https://www.youtube.com/watch?v=HgrG9I51Nbk

or

Date.IsInCurrentYear, Date.IsInNextYear, Date.IsInPreviousYear: https://www.youtube.com/watch?v=Fl0lYeZznTM