Forum Discussion
Power Query - Date Filter | Not last 2 Weeks
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 , 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
2 Replies
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
