date filter skipping date!

[sandeep_potturi]

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.

[PwerQueryKees · Accepted solution]

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...

[sandeep_potturi]

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!

[lbendlin]

I am not familiar with the filter dialog you are showing. Is that used in on-object interaction?

Cannot reproduce the missing value

[sandeep_potturi]

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.

[tharunkumarRTK]

@sandeep_potturi 

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 check 

Hope 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!