Forum Discussion
Group Consecutuve rows (timestamps)
Hi, I have some trouble with grouping consecutive timestamps as 1. The Data is kind of alarmdata, so a row only appears when alarm is on. Every consecutive second it is "on" that means it is the ...
Anonymous
Please see attached file.
I added an Index Column then
I have added 2 custom columns "AlarmStart" and "AlarmEnd"
AlarmStart=let mytime=[timestamp]-#duration(0, 0, 0, 1), myindex=[Index] in try if Table.SelectRows(#"Added Index",each [Index]=myindex-1)[timestamp]{0}=mytime then null else [timestamp] otherwise [timestamp]
Anonymous
Could you copy paste above data in the post (copiable format)?
Anonymous
Please see attached file.
I added an Index Column then
I have added 2 custom columns "AlarmStart" and "AlarmEnd"
AlarmStart=let mytime=[timestamp]-#duration(0, 0, 0, 1),
myindex=[Index] in
try if Table.SelectRows(#"Added Index",each [Index]=myindex-1)[timestamp]{0}=mytime then null else [timestamp]
otherwise
[timestamp]Thanks a lot! I see that your solution works excactly how I want it to work when opening you file.
But when copying it to my file, it gives a different result. (Just the same as the timestamp). Can't figure out what causes the difference.Anonymous
May be your timestamp has milliseconds as well.
Could you send me your file?
would like to, but çan't find the attach file mode? ( i am new on this forum sorry)