Average over the minute

[hokiefan1113]

Hi there,

I'm using a table that has data showing when punch transactions begin, when they've completed, and I've created a 3rd column that calculates the difference (i.e. processing time). Since there is such a massive inflow of data so frequently, I was wondering how I can calculate a column that shows the average inflow of punches (i.e. punch start) per minute, as well as the average processing time per minute. 

Thanks!

[v-yulgu-msft · Accepted solution]

Hi @hokiefan1113,

Please try:

average inflow per minute =
CALCULATE ( COUNT ( Table[Punch Start] ), ALL ( Table ) )
    / DATEDIFF ( MIN ( Table[Punch Start] ), MAX ( Table[Punch Complete] ), MINUTE )

average processing time =
CALCULATE ( SUM ( Table[Processing Time] ), ALL ( table ) )
    / CALCULATE ( COUNTROWS ( Table ), ALL ( Table ) )

Best regards,

Yuliana Gu