Forum Discussion

nzboan's avatar
nzboan
New Member
9 years ago

%Var between previous date

Hey, everyone, I've been trying to calculate this, but I'm really stuck. Here is the problem:   I want to show in % the difference between months of 2016 and 2017. For example :   January 2016: 1...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi nzboan,

 

You can use below formula to calculate the diff between current year month total and previous year month total.

Measure:

Diff = 
VAR CYM =
    CALCULATE (
        SUM ( Records[Amount] ),
        FILTER (
            ALLSELECTED ( Records ),
            YEAR ( [Date] ) = YEAR ( MAX ( [Date] ) )
                && MONTH ( [Date] ) = MONTH ( MAX ( [Date] ) )
        )
    )
VAR PYM =
    CALCULATE (
        SUM ( Records[Amount] ),
        FILTER (
            ALLSELECTED ( Records ),
            YEAR ( [Date] )
                = YEAR ( MAX ( [Date] ) ) - 1
                && MONTH ( [Date] ) = MONTH ( MAX ( [Date] ) )
        )
    )
RETURN
    DIVIDE ( CYM - PYM, PYM, 0 )

 

Regards,

Xiaoxin Sheng