Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

getting monthly averages

Hi All,

 

I have the table below and would want to get the average ticket count per month. how to formulate the measure for this? thanks in advance.

 

MonthTicket Count
Jan-231915
Jan-238
Jan-23122
Jan-2318
Jan-23667
Jan-2322
Jan-232
Jan-231
Feb-231911
Feb-2310
Feb-23181
Feb-2338
Feb-23619
Feb-2314
Feb-232
Mar-232438
Mar-2312
Mar-23118
Mar-2327
Mar-23703
Mar-2314
Mar-233
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    You can create a measure as below first and create a table visual with the setttings as below screenshot:

    Measure = AVERAGE('Table'[Ticket Count])

    Best Regards

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    You can create a measure as below first and create a table visual with the setttings as below screenshot:

    Measure = AVERAGE('Table'[Ticket Count])

    Best Regards