Create shift from time

Question

Hi,&nbsp;I´ve been trying to figure this out. So basically I want to create a new table named "Shift" with only two values: Shift 1 and Shift 2.Shift 1 goes from 07:30 to 19:30 and Shift 2 goes from 19:30 to 07:30. These shifts are for all days of the week.&nbsp;&nbsp;Days of the week are seen as numbers, not text. This is how it looks:&nbsp;&nbsp;Do you guys have any idea how to do it?

pieye · Accepted Answer

Hi&nbsp;ReyDeSirenas&nbsp; in DAX this is simple to achieve as dates and times work similar to numbers, and you can perform greater than / less than comparisons easily.&nbsp;This expression as a&nbsp;calculated column (ie, not measure) in the same table as the time element should work.Shift = "Shift " &amp; If('Days and hours'[Time] &gt;= time(7,30,0) &amp;&amp; 'Days and hours'[Time] &lt; time(19,30,0), 1,2)&nbsp;Result:&nbsp;HTH&nbsp;Pi&nbsp;&nbsp;

Forum Discussion

Create shift from time

2 Replies

Related content

Create time groups/shifts

Time Shifted Measures

Create night shift range

Group Days and create shifts

Create a shift time filter