Forum Discussion

sandeep_potturi's avatar
sandeep_potturi
Frequent Visitor
1 year ago
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...
Need Help
  • PwerQueryKees's avatar
    PwerQueryKees
    1 year ago

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

lbendlin's avatar
lbendlin
Super User
1 year ago

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's avatar
    sandeep_potturi
    Frequent Visitor
    1 year ago

    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's avatar
      tharunkumarRTK
      Super User
      1 year ago

      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!