Alarm Log Page

Hello adarshmp8998 ,  thank you for sharing your question with the Community.   Remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

adarshmp8998 Hi!

Alarm Log =
ADDCOLUMNS(
FILTER(
'Table',
'Table'[Alarm Category] = "Low Temp" &&
NOT(ISBLANK(
CALCULATE(
MAX('Table'[Date Time]),
FILTER(
ALL('Table'),
'Table'[Asset] = EARLIER('Table'[Asset]) &&
'Table'[Date Time] > EARLIER('Table'[Date Time]) &&
'Table'[Alarm Category] = "Clear" &&
'Table'[Date Time] <= EARLIER('End Time') &&
'Table'[Date Time] > EARLIER('Start Time')
)
)
))
),
"Start Time", 'Table'[Date Time],
"End Time",
CALCULATE(
MAX('Table'[Date Time]),
FILTER(
ALL('Table'),
'Table'[Asset] = EARLIER('Table'[Asset]) &&
'Table'[Date Time] > EARLIER('Table'[Date Time]) &&
'Table'[Alarm Category] = "Clear" &&
'Table'[Date Time] > EARLIER('End Time')
)
)
)

BBF

Hi adarshmp8998 ,

Thanks for the reply from BeaBF  and foodd , please allow me to provide another insight: 

Do you need to display different Asset values? If so, you can put the Asset field into the slicer.

If I understand you wrongly, please provide more details so that we can better help you solve the problem.

Best Regards,

Clara Gong

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