Growth rates (Month Over Month) formula

dmitrpav

In this scenario, what are the values in Tables[Month]? If it's just the month part of the date, it will return incorrect result since month number will repeat in every year. So you should also add the Year column as condition in your FILTER() function. Then it will show the previous month total on each row.

Revenue % Change = 
VAR RevenueLastMonth =
    CALCULATE (
        SUM ( Tables[Revenue] );
        FILTER(Tables;
            Tables[Month]
                = ( EARLIER ( Tables[Month] ) - 1 )
                && Tables[Year] = EARLIER ( Tables[Year] )
                && Tables[Country] = EARLIER ( Tables[Country] )
                && Tables[Source] = EARLIER ( Tables[Source] )
        )
    )
RETURN
    IF (
        ISBLANK ( RevenueLastMonth );
        0;
        ( Tables[Revenue] - RevenueLastMonth )
            / RevenueLastMonth
    )

See my sample below:

Regards,