Forum Discussion
null
null
2 Replies
Anonymous ,
A new measure assuming Ending HC is a measure
Measure =
var _max = maxx(allselected(Table), Table[Fiscal Month ID])
var _min = Minx(allselected(Table), Table[Fiscal Month ID])-1
return
calculate(Divide(Sumx(Table, [Ending HC]), _max -_min), filter(all(Table[Fiscal Month ID]), Table[Fiscal Month ID] >=_min && Table[Fiscal Month ID] <= _max ) )
Hi! I have a problem that I have been trying to solve for days. I need to calculate working hours by manufacturing line over multiple days. the problem is I have to do this by time of first unit produced-time of last unit produced for each day. I dont know how to go through each day, take the min time and max time, subtract the two, and add to a running total going through everyday that my date slicer has included. If you are able to help that would be awesome!! Let me know 🙂
Here is some sample data. This will eventually allow me to calculate an accurate "Units per hour".
Line Number Date Time Units 1 9/20/2022 8am 1 1 9/20/2022 10am 1 1 9/20/2022 1pm 1 1 9/20/2022 4pm 1 1 9/21/2022 7am 1 1 9/21/2022 9am 1 1 9/21/2022 11am 1 1 9/21/2022 1pm 1 1 9/22/2022 6am 1 1 9/22/2022 10am 1 1 9/22/2022 2pm 1 2 9/20/2022 8am 1 2 9/20/2022 10am 1 2 9/20/2022 1pm 1 2 9/20/2022 4pm 1 2 9/21/2022 7am 1 2 9/21/2022 9am 1 2 9/21/2022 11am 1 2 9/21/2022 1pm 1 2 9/22/2022 6am 1 3 9/21/2022 10am 1 3 9/21/2022 2pm 1 3 9/22/2022 9am 1 3 9/22/2022 11am 1 3 9/22/2022 1pm 1
