Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 Table'[Year]))

 

 

Date Table (linked):

 

 

 

 

Need Help

3 Replies

  • sevenhills's avatar
    sevenhills
    Super User
    4 years ago

     

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Date Table is a separate table...