List.RemoveItems with condition

[donkey shrek]

I have a column that contains lists of dates. How do I remove dates from those lists where value does not = x?

 

[RoryA]

The second argument to RemoveItems is a list of the items you want removed, so just supply any date/times you want removed there.

 

[RoryA]

Ah, I think I misunderstood. You probably want List.Select instead so you can specify the criteria for the ones you want to keep.

 

[donkey shrek]

The second argument to RemoveItems is a list of the items you want removed, so just supply any date/times you want removed there.

How do I specify it to remove dates where not = to specific date?

 

[donkey shrek]

Ah, I think I misunderstood. You probably want List.Select instead so you can specify the criteria for the ones you want to keep.

This is my current code. Time contains lists of DateTimes. I want to remove values in those lists that contain [Start Date] - a Date value

= Table.TransformColumns(#"Removed Columns1", Time, each List.Select([Time], each _ contains [Start Date]))

 

[RoryA]

I'm sure it is possible with TransformColumns (getting the reference to each row's [Start Date] field eludes me at the moment) but you could use something like this:

=Table.FromRecords(Table.TransformRows(#"Removed Columns1", (row) => Record.TransformFields(row, {"Time", each List.Select(_, (d) => DateTime.Date(d) <> row[Start Date])})))

Or add a column using something like

List.Select([Time], each DateTime.Date(_) <> [Start Date]))

and then remove the original.

 

[donkey shrek]

I'm sure it is possible with TransformColumns (getting the reference to each row's [Start Date] field eludes me at the moment) but you could use something like this:

=Table.FromRecords(Table.TransformRows(#"Removed Columns1", (row) => Record.TransformFields(row, {"Time", each List.Select(_, (d) => DateTime.Date(d) <> row[Start Date])})))

Or add a column using something like

List.Select([Time], each DateTime.Date(_) <> [Start Date]))

and then remove the original.

Thank you! Just changed it abit and it works, this is my final code:

= Table.AddColumn(Custom1, "Custom", each let SD = [Start Date] in List.Select([Time], each DateTime.Date(_) = SD))