Filter date on power query

[Sofino]

Hello all,

please, i need to know how to filter dates on power query with condition " is before 2 months"
for exemple, we are on October 2022, i need to filter all dates that are "before september 2022"
next month November 2022, it will be " before october 2022"

thank you so much

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table7"]}[Content],
    tbl = Table.TransformColumnTypes(Source,{{"Date", type date}}),
    dt = Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1)),
    Result = Table.SelectRows(tbl, each [Date] < dt)
in
    Result

Book1
	A	B	C	D	E	F
1	Item	Date		Item	Date
2	1	1/7/2023		7	6/28/2022
3	2	11/14/2022		8	4/17/2022
4	3	12/24/2022		9	8/31/2022
5	4	12/26/2022		12	6/7/2022
6	5	11/28/2022		16	5/1/2022
7	6	1/29/2023		18	7/11/2022
8	7	6/28/2022
9	8	4/17/2022
10	9	8/31/2022
11	10	9/6/2022
12	11	9/2/2022
13	12	6/7/2022
14	13	9/21/2022
15	14	12/2/2022
16	15	9/19/2022
17	16	5/1/2022
18	17	1/20/2023
19	18	7/11/2022
20	19	1/25/2023
21
Sheet5

 

[Sofino]

let
    Source = Excel.CurrentWorkbook(){[Name="Table7"]}[Content],
    tbl = Table.TransformColumnTypes(Source,{{"Date", type date}}),
    dt = Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1)),
    Result = Table.SelectRows(tbl, each [Date] < dt)
in
    Result

Book1
	A	B	C	D	E	F
1	Item	Date		Item	Date
2	1	1/7/2023		7	6/28/2022
3	2	11/14/2022		8	4/17/2022
4	3	12/24/2022		9	8/31/2022
5	4	12/26/2022		12	6/7/2022
6	5	11/28/2022		16	5/1/2022
7	6	1/29/2023		18	7/11/2022
8	7	6/28/2022
9	8	4/17/2022
10	9	8/31/2022
11	10	9/6/2022
12	11	9/2/2022
13	12	6/7/2022
14	13	9/21/2022
15	14	12/2/2022
16	15	9/19/2022
17	16	5/1/2022
18	17	1/20/2023
19	18	7/11/2022
20	19	1/25/2023
21
Sheet5

thank you so much my friend, it works perfectly.
if i need to add a condition, how can i do that?
for exemple;
Result = Table.SelectRows(tbl, each [Date] < dt and > 01/01/2019)

thank you so much

 

[JGordon11]

Result = Table.SelectRows(tbl, each [Date] < dt and [Date] > #date(2019,1,1))

 

[Sofino]

Thank you so much @JGordon11 that's perfect
have a great day my friend