Shift table w/Date changed to (Datetime) starttime / endtime from Date - reference

[Anonymous]

Shift table changed from Date and shift columns due to 12 hour shifts 7am to 7pm, 7pm to 7am to columns (Date/Time format) startTime and endTime and shift column. Before it had a relationship to Date reference - date and Shift table - Date. How would I create the relationship for the Shift table after the change to get it working properly..

[Anonymous]

We have 4 shifts (2 day shifts and 2 night shifts) and I want to query production losses by shift. It used to be the shift schedule was setup as Days - A/C shift and Nights - B/D Shift. I want to split it up into 4 separate shifts A, B, C ,D. Our data reference is setup by date only, not Date / Time. So when I create the relationship it duplicates A and C shift, and B and D duplicates the losses..

[SivaMani]

@Anonymous, It depends on how you want to analyze the data. If your requirement/dashboard is based on the shift start time, create a datekey column based on starttime and use it in the relationship.

Date Key - YYYYMMDD

M Query -  Date.ToText([DateColumn], "yyyyMMdd")

DAX - FORMAT([DateColumn],"YYYYMMDD")