Re: time intellegence - please help with an formul...

Anonymous · ‎05-06-2018

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 · ‎05-26-2018

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler · ‎05-06-2018

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.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎05-06-2018

Anonymous · ‎05-06-2018

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?

time intellegence - please help with an formula?

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly