Filter dates before current week

[Anonymous]

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!

Start date	Stock	Returns	Defective	Category
01/05/2021	6	9	17	Late
27/05/2022	2	5	10	On time
07/08/2022	5	6	15	On time
14/07/2022	5	6	15	Undefined
08/08/2022	3	4	8	No action
12/08/2022	2	2	10	Late
17/08/2022	7	8	22	On time
20/08/2022	3	3	13	No action
22/08/2022	6	3	18	Late
29/08/2022	3	3	14	On time
18/09/2022	3	3	14	Undefined
07/09/2022	2	7	17	No action
16/09/2022	3	7	22	On time
20/09/2022	9	3	16	On time
23/09/2022	7	5	20	Late
11/10/2022	9	8	18	No action
04/01/2023	6	7	16	On time
17/02/2023	7	14	34	On time
11/12/2022	9	8	18	No action

[wdx223_Daniel]

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

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Try this:

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

Pete