Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
Feb 13, 2025
Solved

Dax to find open status for more than 1 hour

Hi Team,

 

I have the below table:

Here I want to find that whether door is being open for more than 1 hour or not.

The Status column shows whether door is open or not.

CreatedOn column shows time duration.

 

Could you please help me create a dax logic to achieve this?

PFA file here B&M.pbix

 

Thanks in advance!

SergeiBaklan 

Resources