Forum Discussion
Solved
Value Based on time range
Hi there, please help have trivial rutine problem need to define shift number based on time range where: first shift duration from 7:00 to 15:30 second shift duration from 15:30 to 24:00 third shi...
Wirestat , Create a new column like
Switch(true(),
timevalue([Datetime]) < time(7,0,0) , "Third Shift",
timevalue([Datetime]) < time(15,30,0) , "First Shift",
"Second Shift"
)
Hi:
You can do this by making sure those are two separate columns. I used Power Query to do minor set up work. I'll paste below. Here is the calculated column, theTable name is Shift. If you'd like me to send file I can, just realized a lot of miscellaneous things on my pbix.. I hope this helps..
Shift Assigned =
Switch(true(),
Shift[Stand Time]< TIME(7, 0 ,0) , "Third Shift",
Shift[Stand Time] < TIME(15,30,0), "First Shift",
"Second Shift")
thank you, but amitchandak solution looks more compact
