Average Count Per Day

[giorgilomidze]

Hi, 

I have tasks which have start time and end time. 
I took those tasks and distributed them on 24 H basis and it shows me on line chart how task creation and task finishing times are distributed on 24 H x axis. But it shows me the whole count from first period till last day. I need it to show me on average what amount of tasks is created per hour, distributed on 24H x axis. 

[OwenAuger · Accepted solution]

Hi,

It sounds like, for each hourly block, you want to calculate a count per day and average those counts over your entire date range. For that you would need to use the AVERAGEX function.

Treat this as a template as I'm not sure of your table/column names, or whether you have a Date table:

=
AVERAGEX (
    VALUES ( 'Date'[Date] ),
    CALCULATE ( COUNT ( YourTable[YourColumn] ) )
)

A measure like this would work whether you're looking at hourly blocks or complete days.