Forum Discussion
Calculating hours worked over x days excluding down time
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!
davehusMemorable Member
Oddly enough .[Date] didn't work for me when I tried it and I thought it wasn't accepted in a summarize. 😊 if I've helped you, please accept my solution, if not let me know if there is anything else I can do.
- davehus
Sorry, my mistake. Are you able to add columns in power query. If so create a custom column with Date.From([DateTimeCol]) call it something like date only and the replace the datetime with the date only column on the summarize table.
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.