How to calculate % Change

Hi Sunilrane,

It seems that there are only two columns in your table:

So you may create two columns to extract the Date and the Type:

Date =
RIGHT ( [[All Periods]]], 8 )

Type =
VAR _findWks =
    FIND ( "Wks", [[All Periods]]] )
RETURN
    LEFT ( [[All Periods]]], _findWks + 2 )

Output:

Then create a measure 

Changed Percentage =
VAR _current =
    SUM ( 'Table'[[$]]] )
VAR _previous =
    CALCULATE (
        SUM ( 'Table'[[$]]] ),
        FILTER (
            ALL ( 'Table' ),
            [Type] = MAX ( 'Table'[Type] )
                && YEAR ( [Date] )
                    = YEAR ( MAX ( 'Table'[Date] ) ) - 1
        )
    )
RETURN
    DIVIDE ( _previous, ( _current - _previous ) )

And change the format to Percentage

The final output:

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