Forum Discussion
Solved
How To Create a Start Time and Finish Time Based on Out Time and Index Using Power Query
Hello everyone. I've been trying to find a solution to my timing issue, but still not getting the expected results. Let me explain. I have 3 important columns (INDEX, PRODDATE, MACHINE) and 1 refere...
Hi
Table.Combine(
Table.Group(
#"Previous Step",
{"INDEX"},
{{"Data", each Table.FromColumns(
Table.ToColumns(_) &
{{[PRODDATE]{0} & #time(7,0,0)} & List.RemoveLastN([OUTTIME],1)} &
{List.RemoveLastN([OUTTIME],1) & {Date.AddDays([PRODDATE]{0},1) & #time(7,0,0)}},
Table.ColumnNames(_) & {"STARTPRODTIME","FINISHPRODTIME"})
}},
GroupKind.Local,
(x,y) => if y[INDEX]=1 then 1 else 0)
[Data])Stéphane
Hi
Table.Combine(
Table.Group(
#"Previous Step",
{"INDEX"},
{{"Data", each Table.FromColumns(
Table.ToColumns(_) &
{{[PRODDATE]{0} & #time(7,0,0)} & List.RemoveLastN([OUTTIME],1)} &
{List.RemoveLastN([OUTTIME],1) & {Date.AddDays([PRODDATE]{0},1) & #time(7,0,0)}},
Table.ColumnNames(_) & {"STARTPRODTIME","FINISHPRODTIME"})
}},
GroupKind.Local,
(x,y) => if y[INDEX]=1 then 1 else 0)
[Data])
Stéphane
It works. Terima kasih for your help 😁🇮🇩