Power Query

[gheyman]

I know how to create a list from a table, where the user enters info, and use that to "Filter" data.

Example: #"Filtered Rows" = Table.SelectRows(ModelPropricer_vdataProposalMaterial, each List.Contains(SelectedProposal,[ParentId]) or List.NonNullCount(SelectedProposal)=0)

How can I do something similar with a date? I want to filter to a date but I want it where it filters to equals or is greater than the date.

The name of the list is Start_Date [Start Date]
The name of the table I am filtering is Search_Results and the field I want to filter is StartDate

Thanks for the help and lesson!

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Search_Results"]}[Content],
    tbl = Table.TransformColumnTypes(Source,{{"StartDate", type date}}),
    DateFilter = Date.From(Excel.CurrentWorkbook(){[Name="FilterDate"]}[Content][Filter Date]{0}),
    Result = Table.SelectRows(tbl, each [StartDate] >= DateFilter)
in
    Result

Book3
	A	B	C	D	E	F	G	H
1	StartDate	Item		StartDate	Item		Filter Date
2	3/31/2022	A		6/9/2022	B		4/30/2022
3	6/9/2022	B		6/1/2022	C
4	6/1/2022	C		6/8/2022	H
5	3/24/2022	D		5/21/2022	I
6	3/27/2022	E		5/2/2022	J
7	4/16/2022	F		6/13/2022	K
8	3/17/2022	G		6/8/2022	L
9	6/8/2022	H
10	5/21/2022	I
11	5/2/2022	J
12	6/13/2022	K
13	6/8/2022	L
14
Sheet1