Alarm Log, Start Time & End Time in Power BI Visual

Hi, adarshmp8998 

You can create a new table. the following is the dax:

Alarm Log = 
ADDCOLUMNS(
    FILTER(
        'Table',
        'Table'[State Number] <> 1 && 
        'Table'[State Number] <> 2 && 
        'Table'[State Number] <> 3
    ),
    "Start Time", 'Table'[Date Time],
    "End Time", 
    CALCULATE(
        MIN('Table'[Date Time]),
        FILTER(
            ALL('Table'),
            'Table'[Asset] = EARLIER('Table'[Asset]) && 
            'Table'[Date Time] > EARLIER('Table'[Date Time]) && 
            ('Table'[State Number] = 1 || 
            'Table'[State Number] = 2 || 
            'Table'[State Number] = 3)
        )
    )
)

Here is my preview:

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.