Think my logic is off here but I always seem to struggle with things like this:

formatTest = IF(
                CALCULATE([%Cancelled],MONTH(****[ApplicationDate]) =MONTH(TODAY()),DISTINCT(****[Name])) < 
                CALCULATE([% Cancelled],MONTH(****[ApplicationDate]) = MONTH(TODAY())-1,DISTINCT(****[Name])),
                "#008000",
                "#FFFFFF")

I want a cell in a matrix table to be coloured green if it is lower than the previous month's value, the current formula works in terms of the date, but it colours the entire column green as it is lower at an overall level, i want it to go down to the by each name level.

Table looks like:

            Last month     This month

Name

Name

Name

Name

Apologies if I am not explaining myself very well.