getting monthly averages

[gheecalipes25]

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.

Month	Ticket Count
Jan-23	1915
Jan-23	8
Jan-23	122
Jan-23	18
Jan-23	667
Jan-23	22
Jan-23	2
Jan-23	1
Feb-23	1911
Feb-23	10
Feb-23	181
Feb-23	38
Feb-23	619
Feb-23	14
Feb-23	2
Mar-23	2438
Mar-23	12
Mar-23	118
Mar-23	27
Mar-23	703
Mar-23	14
Mar-23	3

[v-yiruan-msft · Accepted solution]

Hi @gheecalipes25 ,

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