Forum Discussion
Solved
List.First(List.Select()) comparing column table to containing table
background: I have in my main table a CreateDate. I have created a column of data from the main table, for each row, it contains 1 or more records. I am trying to grab the First Date from the newtab...
sorry, there was an Earlier missing:
= Table.AddColumn(#"Added Custom3", "StartDate2", (Earlier) => List.First( List.Select(Earlier[NewTable][CreateDate], each _ < Earlier[CreateDate] )))
