https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Group-Consecutive-timestamps/m-p/715283#M1204 <P>Hi,</P><P>&nbsp;</P><P>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 same alarm that is still "on". So as you see:</P><P>timestamp 22:29:05 until 22:29:14 is consecutive. &lt;---- one alarm = duration 9 seconds.&nbsp;&nbsp;</P><P>timestamp 22:29:16 until 22:29:20 &lt;--- other alarm. etc.</P><P>&nbsp;</P><P>I would want to group the rows that have consecutive seconds. Therefor this table will consist of 4 different alarms.&nbsp;<BR />I think the best way is to creat a alarm starttime with the first timestamp per alarm and a column endtime.<BR /><BR />Anybody that can help me with this?</P><P><img /></P> Fri, 14 Jun 2019 14:28:28 GMT Anonymous 2019-06-14T14:28:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Group-Consecutive-timestamps/m-p/715283#M1204 <P>Hi,</P><P>&nbsp;</P><P>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 same alarm that is still "on". So as you see:</P><P>timestamp 22:29:05 until 22:29:14 is consecutive. &lt;---- one alarm = duration 9 seconds.&nbsp;&nbsp;</P><P>timestamp 22:29:16 until 22:29:20 &lt;--- other alarm. etc.</P><P>&nbsp;</P><P>I would want to group the rows that have consecutive seconds. Therefor this table will consist of 4 different alarms.&nbsp;<BR />I think the best way is to creat a alarm starttime with the first timestamp per alarm and a column endtime.<BR /><BR />Anybody that can help me with this?</P><P><img /></P> Fri, 14 Jun 2019 14:28:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Group-Consecutive-timestamps/m-p/715283#M1204 Anonymous 2019-06-14T14:28:28Z