Forum Discussion
Group Consecutuve rows (timestamps)
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
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)
Anonymous
You can upload it to onedrive or googledrive and share link here
Or you can email me as well