Forum Discussion
Calculating hours worked over x days excluding down time
Memorable MemberHi KellerB ,
I've attached a solution using a summarized table. Let me know if this meets your needs.
Did I help you today? Please accept my solution and hit the Kudos button.
I just realized my date column contains the day and time so the table creates a new row for everytime. how do i create a new column for just the date? I would like to avoid changing my existing date column as i have measures using it.
Like this? Its giving me an error
Ok I used .[date] on the end and that seemed to work. However I realized that I am have separate shifts....
Day shift = 5am-6pm
Night Shift = 10pm-6am
I already have in my table what shift each row belongs to so I just need to somehow get it in the summarized table calculation.
THanks for all your help!
Are you able to do a virtual call sometime tomorrow or next week? I feel like i am not good at explaining what is not working haha.
- davehus
Yes sure. Next week is fine if that suits. Private message me on the community and we'll go from there.