How to adjust DAX measure to include multiple values?

Hi HB13 ,

Please try this:-

VAR max_Year_ =
    MAX ( _DateTable[Years] )
VAR min_Year_ =
    MIN ( _DateTable[Years] )
RETURN
    CALCULATE (
        SUM ( Table1[PremiumVAT] ),
        FILTER (
            Table2,
            Table2[InceptionDate].[Year] <= max_Year_
                && Table2[InceptionDate].[Year] >= min_Year_
        )
    )
        + CALCULATE (
            SUM ( Table1[PremiumExclVAT] ),
            FILTER (
                Table2,
                Table2[InceptionDate].[Year] <= max_Year_
                    && Table2[InceptionDate].[Year] >= min_Year_
            )
        )

BR,

Samarth