I have been tasked with determining when our machines are being started and stopped every day. We have a system to record this information into a table. I need to use Power BI to find the earliest start time and latest stop time within a shift window. I believe I have first and second shift worked out. The problem is third shift since the date rolls over after midnight. How do you handle date rollover in Power BI. Am I overthinking it. I have attached the PBIX and the measure I am working with is Machine Start Time Third.
SFC6 Downtime.pbix (1.5 MB)
Welcome back to Forum.
Maybe you can clarify more about the problem you have - for example when third shift start / end, and some example of your downtime what you try to achieve ? Several examples + with columns