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 same alarm that is still "on". So as you see:
timestamp 22:29:05 until 22:29:14 is consecutive. <---- one alarm = duration 9 seconds.
timestamp 22:29:16 until 22:29:20 <--- other alarm. etc.
I would want to group the rows that have consecutive seconds. Therefor this table will consist of 4 different alarms.
I think the best way is to creat a alarm starttime with the first timestamp per alarm and a column endtime.
Anybody that can help me with this?
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - July 2024
Check out the July 2024 Power BI update to learn about new features.
Fabric Community Update - July 2024
Find out what's new and trending in the Fabric Community.
