Power Query: Filter a table based on a date in a List

[gheyman]

I want to filter a table in Power Query to only show items where the data is = or > the date in a List (and if the the list is null to show all)

My list name is User_CostSource_Date. The date field name, in the table I want to filter, is [StartDate].

Thanks!

 

[RoryA]

Do you mean you have multiple dates in a list, or just one?

 

[gheyman]

Just one.

 

[RoryA]

You should be able to filter using

User_CostSource_Date{0}

then?

 

[gheyman]

I'm sorry, Rory. But I am lost I was thinking there was a formula for Dates similar to filtering other data types. Similar to how this one filters

LIST CONTAINS

'=Table.SelectRows(ModelPropricer_vdataProposalMaterial, each List.Contains(SelectedProposal,[ParentId]) or List.NonNullCount(SelectedProposal)=0),

But for a date where its equal to or greater than the one date in the List.

 

[RoryA]

You'd just do a straightforward [field]>=User_CostSource_Date{0} would you not?

 

[gheyman]

I dont know. But I will try that. Thank you!