Forum Discussion
Solved
Create a new column based on dates group
Hello all, I have two columns: TimeStamp and LoadDate. I would like to create a third column, LoadID based on this criteria: Dates between 23-06-2022 and 04-07-2022 in TimeStamp should have Load...
=Table.FillUp(Table.FromColumns(Table.ToColumns(PreviousStepName)&{List.Skip(PrevousStepName[LoadDate])},Table.ColumnNames(PreviousStepName)&{"LoadID"}),{"LoadID"})
=Table.FillUp(Table.FromColumns(Table.ToColumns(PreviousStepName)&{List.Skip(PrevousStepName[LoadDate])},Table.ColumnNames(PreviousStepName)&{"LoadID"}),{"LoadID"})