Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter dates before current week

Hello, I have the following table in Power Query and i am trying to filter all rows based on the Start date before the Monday date of the current week. Is this possible? Any help is much appreciated...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Anonymous ,

     

    Try this:

    Table.SelectRows(
    previousStepName,
    each [Start date] < Date.StartOfWeek(Date.From(DateTime.LocalNow()), Day.Monday)
)

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

Hi Anonymous ,

 

Try this:

Table.SelectRows(
    previousStepName,
    each [Start date] < Date.StartOfWeek(Date.From(DateTime.LocalNow()), Day.Monday)
)

 

Pete