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)
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_out
You may want to add a weekday sort column.
wd = WEEKDAY('Table'[event_time]-1/6,2)