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

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

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