Conditional Formatting With Average of Previous 3 Months

[ddhingra]

I have month wise Depatrment wise Consumption. Now i  want to take Average of Previos 3 month consumption.

In case consumption of current month is more than average of previous 3 months, then i want red sign next to the current month value in my table and in case it is less than the average of previous 3 months, then i want green sign next to the current month value.

Sample table below

[tamerj1]

Hi @ddhingra 
You can try the following format measure, 1 is green and 0 is red

Formatting Measure =
VAR CurrentConsumption = [Consumption]
VAR Average3MonthsConsumption =
    AVERAGEX (
        TOPN (
            3,
            SUMMARIZE (
                ALLSELECTED ( 'Table' ),
                'Date'[YearMonth],
                "@Consumption", CALCULATE ( [Consumption], ALL ( 'Date'[MonthName] ) )
            ),
            'Date'[YearMonth], ASC
        ),
        [@Consumption]
    )
RETURN
    INT ( Average3MonthsConsumption > CurrentConsumption )