Sum of values

Hi Anya_T ,

Create a column with below code:-

H's = 
var month_num = Month(DATEVALUE('Table (6)'[Year]&"/"&'Table (6)'[Month ]&"/"&"1"))
return if(month_num <= 6,"H1","H2")

Now create a measure like this:-

Comparision =
VAR H1_2020 =
    CALCULATE (
        SUM ( 'Table (6)'[Values] ),
        'Table (6)'[Year] = 2020,
        'Table (6)'[H's] = "H1"
    )
VAR H1_2021 =
    CALCULATE (
        SUM ( 'Table (6)'[Values] ),
        'Table (6)'[Year] = 2021,
        'Table (6)'[H's] = "H1"
    )
RETURN
    H1_2021 - H1_2020

Thanks,

Samarth