Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter days based on weekday

Hi Everyone,   I have a scenario wherein I want to filter the data on date column based on current day in the query editor.   If refreshing on Monday, filter data from last 3 days(Sunday, Saturda...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try = Table.SelectRows(#"Added Custom", each [StartDate] >= Date.From(Date.AddDays(DateTime.LocalNow(), (-1 * (if Date.DayOfWeek(DateTime.Date(DateTime.FixedLocalNow())) =0 then 3 else 1 )))))

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try like

 

Table.SelectRows(#"Added Custom4", each [StartDate] >= Date.From(Date.AddDays(DateTime.LocalNow(), -1* if Date.DayOfWeek(DateTime.Date(DateTime.LocalNow())) =0 then 3 else 1)))

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Amit. I tried the formula & unfortuantely got a syntax error. Please assist

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      Anonymous , Try = Table.SelectRows(#"Added Custom", each [StartDate] >= Date.From(Date.AddDays(DateTime.LocalNow(), (-1 * (if Date.DayOfWeek(DateTime.Date(DateTime.FixedLocalNow())) =0 then 3 else 1 )))))

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        This works like a charm. Had to change the DayOfWeek to get the desired results. Thanks a ton!!