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?
Do not know how to insert my picture here?
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.
Proud to be a Super User!
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?
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?
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!