Forum Discussion
Solved
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. Th...
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
