Average for EACH month only

HI Anonymous,

You can create a measure formula to calculate the aggregate value based on your date field 'year' and 'month' parts.

Measure formula:

 

Measure =
VAR currDate =
    MAX ( Table[Date] )
RETURN
    CALCULATE (
        AVERAGE( Table[Amount] ),
        FILTER (
            ALLSELECTED ( Table ),
            YEAR ( [Date] ) = YEAR ( currDate )
                && MONTH ( [Date] ) = MONTH ( currDate )
        )
    )

 

Regards,

Xiaoxin Sheng