Calculation within a Column

Hi JuliaWendel

Try this solution.

If you donot have a column for Month Numbers... add this calculated column

Month_Number =
SWITCH (
    Table1[Months],
    "January", 1,
    "February", 2,
    "March", 3,
    "April", 4,
    "May", 5,
    "June", 6,
    "July", 7,
    "August", 8,
    "September", 9,
    "October", 10,
    "November", 11,
    "December", 12
)

Now you can get the desired difference column using below

Difference =
VAR PreviousMonthValue =
    CALCULATE (
        SUM ( Table1[Product Launch] ),
        FILTER (
            ALL ( Table1 ),
            Table1[Month Number]
                = EARLIER ( Table1[Month Number] ) - 1
                && Table1[Year] = EARLIER ( Table1[YEAR] )
        )
    )
VAR PreviousMonthValueforJan =
    CALCULATE (
        SUM ( Table1[Product Launch] ),
        FILTER (
            ALL ( Table1 ),
            Table1[Month Number] = 12
                && Table1[Year]
                    = EARLIER ( Table1[YEAR] ) - 1
        )
    )
RETURN
    Table1[Product Launch]
        - IF ( Table1[Month_Number] = 1, PreviousMonthValueforJan, PreviousMonthValue )

JuliaWendel

Hi JuliaWendel,

Have you tried the solution provided by Zubair_Muhammad above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

If you still have any question on this issue, feel free to post here. :smileyhappy:

Regards