Conditional formatting in matrix based on growth between months

Hi ivan_abboud ,

Assume you have a 'DateTable' :

1-Create this calculated column in 'DateTable':

YearMonthIndex = (DateTable[Year])*12+DateTable[Month]

2-Assume Your measure Name is [Sales]=SUM('Table'[SalesAmount]) . Create the measure below:

SalesPrevMonth=
CALCULATE (
    [Sales],
    FILTER (
        ALL ( 'DateTable' ),
        'DateTable'[YearmonthIndex]
            = MAX ( 'DateTable'[YearmonthIndex] ) - 1
    )
)

3-Then Create the measure:

SalesDiff=
[Sales]-[SalesPrevMonth]

4-Then you can set conditional formatting by the [SalesDiff] Measure. (Greater and less than 0 condition on it)

If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.

Regards,
Loran