time intellegence - please help with an formula?

[Anonymous]

So here I have people intering into and out of a room

I need to write a formula hoe to calculate how long that person has been in a room?

Just cant get it right? Any advice?

thanks

 Do not know how to insert my picture here?

[v-yulgu-msft]

Hi @Anonymous,

Would you please provide more description about your requirement? From above sample table, which columns should be referred to? How to determine when a user inter into or exit out?

Regards,

Yuliana Gu

[Greg_Deckler]

Please paste sample/example TEXT data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But, in general, use DATEDIFF.

[Anonymous]

[Anonymous]

ok posted a picture, but a bit more difficult than that

Need to track where the next entry is, that will be the exit and then I need to calculate it?