How to divide values from Same column based on filter

Hi mohanpal 

If you accept a DAX method, you can create a calculated column with below DAX. This will add a new column to the table. 

Percentage =
VAR _projectionA =
    MAXX (
        FILTER (
            'Table',
            'Table'[Id] = EARLIER ( 'Table'[Id] )
                && 'Table'[Year] = EARLIER ( 'Table'[Year] )
                && 'Table'[Label] = "A"
        ),
        'Table'[Projection]
    )
VAR _projectionB =
    MAXX (
        FILTER (
            'Table',
            'Table'[Id] = EARLIER ( 'Table'[Id] )
                && 'Table'[Year] = EARLIER ( 'Table'[Year] )
                && 'Table'[Label] = "B"
        ),
        'Table'[Projection]
    )
RETURN
    DIVIDE ( _projectionA, _projectionB )

----------------------------------------------------------------------

If this reply helps solve the problem, please mark it as Solution! Kudos are appreciated too!