Forum Discussion
calculate average per month
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 Tabl...
sevenhills
Super User
Super User
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.