calculate average per month

[Anonymous]

Hallo,

I would like to calculate average per month but so far its constant (3.3😞

Completion 2022 = CALCULATE(AVERAGE('Daily Issues'[Completion_Time]),'Date Table'[Year]=MAX('Date Table'[Year]))

Date Table (linked):

 

[Anonymous]

Date Table is a separate table...

[Anonymous]

field 'Daily Issues'[Completion_Time] is not a measure but its a calculate column, it doesnt allow me to insert it..other solution?

[sevenhills]

Try this and see if it works...

Completion 2022 = AVERAGEX (
VALUES ('Date Table'[Year] ) 
, 'Daily Issues'[Completion_Time])
)

Replace, 'Date Table'[Year] with "YYYYMM" or "MMM" per your needs.