Forum Discussion

giorgilomidze's avatar
giorgilomidze
Resolver I
8 years ago
Solved

Average Count Per Day

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 distribut...
Need Help
  • OwenAuger's avatar
    OwenAuger
    8 years ago

    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.

OwenAuger's avatar
OwenAuger
Super User
8 years ago

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.