Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How would I split/define the following work shifts
Example for Work Date - June 30, 2018
Shift times
3rd shift is first
Did you every figure this out? I am having the same issue with a shift ending at 1AM and it is taking the start of the previous day.
Hi @Anonymous
Is this close to your goal?
3rd1 = CONCATENATE(CONCATENATE([date]-1,"@"),TIME(23,0,0))
3rd2 = CONCATENATE(CONCATENATE([date],"@"),TIME(6,59,59))
1st1 = CONCATENATE(CONCATENATE([date],"@"),TIME(7,00,00))
1st2 = CONCATENATE(CONCATENATE([date],"@"),TIME(14,59,59))
2nd1 = CONCATENATE(CONCATENATE([date],"@"),TIME(15,00,00))
2nd2 = CONCATENATE(CONCATENATE([date],"@"),TIME(22,59,59))
Best Regards
Maggie
Sort of, however, I am trying to use that data to filter to a shift.
Ex. a problems occured @
8/16/2018 11:15pm (which is our 8/17/18)
8/17/2018 02:00 am
8/17/2018 11:20pm
When filtered by day or shift the firse and second items should be 8/17/18 3rd shift and the third should be 8/18/18 3rd shift
Very difficult to say specifically without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, the HOUR function returns a number between 0 and 23 so that's probably your best bet.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |