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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
