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 LoadID = 05-07-2022,
dates between 05-07-2022 and 27-07-2022 in TimeStamp should have LoadID = 28-07-2022, and so on.
Do you have any suggestion?
=Table.FillUp(Table.FromColumns(Table.ToColumns(PreviousStepName)&{List.Skip(PrevousStepName[LoadDate])},Table.ColumnNames(PreviousStepName)&{"LoadID"}),{"LoadID"})
1 Reply
=Table.FillUp(Table.FromColumns(Table.ToColumns(PreviousStepName)&{List.Skip(PrevousStepName[LoadDate])},Table.ColumnNames(PreviousStepName)&{"LoadID"}),{"LoadID"})