null

[datagorillagirl]

null

[amitchandak]

@datagorillagirl ,

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 ) )

[KellerB]

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