Forum Discussion
Help with Time Measurement with Day Break
Hi In our Daily report we calculate our production from the production which has happened from 8:30 AM 01/01/2021 to 8:29 AM 02/01/2021 on the next Day as the production figures. But when we make it...
Anonymous
Also you might need to create a measure to filter the production time, make it between the start time and endtime.
Measure = CALCULATE(MAX([Production]),FILTER('Table',[DateTime]>=[Starttime]&&[DateTime]<=[Endtime]))
Not sure how did you record your data. It would be more clear if you can share a sample and expected output in table.
Regards
Paul