Measure Running Sum Up To A Point

Hi Anonymous ,

I create a sample using the function of switch  you can have a try.

Measure =
CALCULATE (
    SUM ( Triangles_Merged[Gross Gross Premiums] ),
    FILTER (
        ALLSELECTED ( Triangles_Merged ),    
                Triangles_Merged[DevelopmentMonth] <= MAX ( 'Development Months'[DevelopmentMonth] ) 
    ),VALUES(Triangles_Merged[year])
)

Measure 2 =
SWITCH (
TRUE (),
MAX( Triangles_Merged[year] ) = 2017, CALCULATE (
'Development Months'[Measure],
FILTER ( 'Development Months', 'Development Months'[DevelopmentMonth] <= 30 )
),

MAX( Triangles_Merged[year] ) = 2018, CALCULATE (
'Development Months'[Measure],
FILTER ( 'Development Months', 'Development Months'[DevelopmentMonth] <= 18 )
),

MAX( Triangles_Merged[year] ) = 2019, CALCULATE (
'Development Months'[Measure],
FILTER ( 'Development Months', 'Development Months'[DevelopmentMonth] <= 6 )
),
BLANK ()
)

Best Regards,

Xue Ding

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