Forum Discussion
Helper IIDetermine 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
Super UserHi Brett,
You can use merge queries option in the Query editor with left outer join. To recreate a solution for you, please post the full data model and sample tables with expected output.
brett_waltonThanks 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")
- BhaveshPatel
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