Forum Discussion
Solved
date filter skipping date!
So i have dates in a table which is basically fridays. Today im noticing that 6/20 somehow isnt being recognized when im doing this filter: 'is latest' works and picks up 6/27 which exis...
Add in the formula bar the following to your SelecxtRows():
or Date.IsInCurrentWeek([WEEK_END_DATE])I could not find a way to create the full filter using the dialog boxes: The advanced filter does not support Last 5 weeks and the basic filter does not support this week...
I am not familiar with the filter dialog you are showing. Is that used in on-object interaction?
Cannot reproduce the missing value
hi,
use this file as your source.
in the power query editor, click 'in the previous'
type 3 and pick weeks then do or 'is latest'
click ok
and then for me, 6/20 disappears...cant figure it out.