Running Totals for Two Years

Hi,

You may download my PBI file from here.

Hope this helps.

Hi cborde3 ,

You can update the formula of measure as below to get the culmulative values, please find the details in the attachment.. If you want to get the value for the specific year, you can add the condition: YEAR(_seldate)=2022 to get it.

Sample 2022 Cumulative Errors = 
VAR _seldate =
    SELECTEDVALUE ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        SUM ( Sheet1[Distinct] ),
        FILTER ( ALLSELECTED ( Sheet1 ), 'Sheet1'[Date] <= _seldate )
    )

Best Regards