Forum Discussion
Determine Shift Based on time range
For the Solution I have created two tables,
Dimension table has all the master information of location, shift no, start and end times.
Fact Table has all the transactional information abouth the location and Persons and Start time. Please see the attached screenshots.
RelationshipsCreate calculated column using DAXfilter BlanksFinal output
Thanks for the reply ... I have a table that list production and its time and I want to determine shift based on the define shifts in the table in my original post
so for the table below and determine the first one is shift 1 (because its between the start and end times for the shifts in the shift table) .. the second one would be shift 2 , Make sense ?
Loc 1 10 pcs 05:20:00 (want to add a shift column that says "1")
Loc 2 50 pcs 14:43:50 (want to add a shift column that says "2")
For the Solution I have created two tables,
Dimension table has all the master information of location, shift no, start and end times.
Fact Table has all the transactional information abouth the location and Persons and Start time. Please see the attached screenshots.
RelationshipsCreate calculated column using DAXfilter BlanksFinal output