Rolling total since specific date

HI kadapavel ,

You can consider to add a if statement with conditions to compare current date and specific date:

POwer bi DAX =
VAR currDate =
    MAX ( 'Sheet1'[ResultDate] )
VAR selected = 'specific datevalue'
RETURN
    CALCULATE (
        SUM ( 'Sheet1'[Result] ),
        FILTER (
            ALL ( Sheet1 ),
            IF (
                currDate < selected,
                'Sheet1'[ResultDate] <= currDate,
                'Sheet1'[ResultDate] >= selected
                    && 'Sheet1'[ResultDate] <= currdate
            )
        )
    )

Regards,

Xiaoxin Sheng