Cumulative total/Occupancy help

[molzmad]

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 do this ?

Picture posted below

I'm Pretty new to power bi and cant seem to figure it out, thanks 🙂 

[v-luwang-msft]

Hi @molzmad ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[lbendlin · Accepted solution]

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)

[lbendlin]

Please provide sample data in usable format (not as a picture) and show the expected outcome.

[molzmad]

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.