Forum Discussion
Shift table w/Date changed to (Datetime) starttime / endtime from Date - reference
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...
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")