Forum Discussion
Solved
Cumulative total/Occupancy help
Hi, I'm basically trying to figure out an occupancy calculation based on people entering/exiting a club, i'm also wanting this reset at 4am every day when the club closes. Would anyone know how to d...
This looks great. As for the 4am cutoff - that is easy to do - you can subtract 1/6 from the event_time value to shift the day assignment.
Weekday = FORMAT('Table'[event_time]-1/6,"DDDD")You don't need any of the other calculated columns, just sum in_or_outYou may want to add a weekday sort column.
wd = WEEKDAY('Table'[event_time]-1/6,2)
Please provide sample data in usable format (not as a picture) and show the expected outcome.
https://drive.google.com/file/d/1WBVg1oMoV36Jl8yBzWVHK5c33TtjbYFg/view?usp=sharing
Hey, here is the data ^ , i would like the outcome to be the occupancy of people in the building as seen in the picture below based on ins (1) and outs (-1) - i would also like the occupancy to reset at 4am every day.
Thanks so much, i really appreciate your help.
