Difference in percentage points between value for last month and the month before?

[Anonymous]

Greetings. 

I have two types of compliance percentages (Contractcompliance and Purchasing compliance) for each month.

I need to calculate the difference between last months compliance (both types) and the month before. 

Last month is always the latest set of data. (Data is loaded once a month).

I need the difference displayed in percentage points, so if it goes from 80,0 to 81,0, the difference would show + 1,0.

Is this possible and if so, how?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Due to I don't know your data model, here I will create a sample to have a test.

Measure:

Contractcompliance difference =
VAR _LASTMONTH =
    CALCULATE (
        SUM ( 'Table'[Contractcompliance] ),
        FILTER (
            'Table',
            'Table'[Date]
                IN CALENDAR ( EOMONTH ( TODAY (), -2 ) + 1, EOMONTH ( TODAY (), -1 ) )
        )
    )
VAR _BEFORE =
    CALCULATE (
        SUM ( 'Table'[Contractcompliance] ),
        FILTER (
            'Table',
            'Table'[Date]
                IN CALENDAR ( EOMONTH ( TODAY (), -3 ) + 1, EOMONTH ( TODAY (), -2 ) )
        )
    )
RETURN
    _LASTMONTH - _BEFORE

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.