Forum Discussion
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 exists as the max date in my table. But the 'in the previous 5 weeks' is missing 6/20. Any ideas? I see 6/20 just fine in the database.
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...
5 Replies
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...
that was totally it.
Didnt realize i was in the current week and that it wouldnt get picked up under "previous" and "latest". Thank you!
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.
You filter condition in the above screenshot is, "IS IN PREVIOUS 3 WEEKS" OR "LATEST"
so, as per "IS IN PREVIOUS 3 WEEKS" - 13th June, 6th June and 30th May
"LATEST" : 27th June i.e the max date in your data. Results are correct.
20th June is current week, NOT the PREVIOUS week.
even if you select next 3 weeks you will not see 20th June, you can test and checkHope this answers your question
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
