Forum Discussion

Nester7929's avatar
Nester7929
Regular Visitor
2 years ago

Difference from previous value in same column (matrix)

Greetings, I'm trying to add a column that will calculate the change from the previous year.  Unfortunately, the years run from November to October, so I'm having some difficulty since I can't use t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Nester7929 

You can create a measure as follows:

diff =
VAR _pre =
    CALCULATE (
        [Cumulative New],
        FILTER (
            ALLSELECTED ( Table ),
            EOMONTH ( [Date], 0 ) = EOMONTH ( MAX ( table[Date] ), -1 )
        )
    )
RETURN
    [Cumulative New] - _pre

Best Regards!

Yolo Zhu

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